2 subforms (similiar) on Main form dropdown/sub

B

babs

I have two subforms (duplicate of the same subform) (don't think I want
that)on a main form

The subforms are temp. for two differernt mixers. One subform for EACH Mixer
(1&2) I would like ONE dropdown field for each subform that I only need to
enter in 1x - mixer 1 that's needs to be selected for top subform and mixer 2
for bottom subform -


When I add a record to subform 1 it automaically displays in subform2- would
like it all to go back to the same table since all the fields are the same.
don't want table for cooker1 and one for cooker 2

not sure where to put drop down to apply to all record for each given subform.

If I put it on the main form that can't tell wether is belongs to top or
bottom subform ( all
other fields on main form pertain to BOTH subform) If put it ON subform than
need to select it for each new record?????


really not sure how to handle 2 subforms on mainform obviously


Thanks,
Barb
 
Top