Creating record in subform with combo box

[hootyeah]

I am wanting to create a new record with default values in a subform
when I select an option in a combo box - which would be on the parent
form. Can this be done??

For eg - On my "Jobs" form I would select the option "Dry Hire" on my
combo box which selects the job type. When "Dry Hire" is selected this
automatically creates a record in the subform "JobRooms" which displays
default data pertaining to a Dry Hire. It is important that certain
field have default data so that the automatically-created record shows
in a query with several tables. I have tried to experiment with
inner-joins in queries without much success - get a message about
"ambiguous outer joins".

Can this be done??

Cheers

 

[Guest]

the default property for the combo box in the subform will look like:

=[forms]![ParentFormName]![ComboBoxName]