Creating new record from Combobox selection

Hi there,

I want to create a new record in the table associated with my main form based on a combobox selection in a subform.

The record sources on my main form come from my "Event" table, which has its own primary key, a description field, and 2 fields containing the primary keys from my "Event Type" and "Event Site" tables.

My first subform has a Combobox that lists Event Types from my "Event Type" table. My second subform is linked to my "Event Site" table and contains text boxes where the user can input Event Site Name, Address, and Contact Information. I want to use the information input on both subforms to create a new entry in my "Event" table.

Basically, I want to take the info selected/typed on this form and:
A) Create a new entry in my "Event Site" table (using data entered in subform 2)
B) Create a new entry in my Event table using the input from the Combobox (in subform 1) and the newly created primary key from part A.

Do I need to separate forms to review the "Event" info versus input new entries?

I volunteered to do this to help organize the Sierra Club's volunteer database and think I've bitten off more than I can chew! Any help would be GREAT!

Thanks!