C
cinnie
I'm new at this, so I hope I can explain my situation accurately...
I have a continuous form (frmResidentMenu_Match, based on
qryResidentMenu_Match) showing txtResidentName and txtMenuRequest in the
form's detail area. I need to be able to add new rows to this form from
existing lists of residents and menus, so I've put two UNBOUND combo boxes in
the form's header (cboResidentName and cboMenuRequest with row sources
tblResidentName and tblMenuRequest respectively). When the cbo's are filled,
I want to click an ADD button in the header to have the new entry added to
the forms detail section.
a) Is this the correct approach?
b) Can someone help this newbie with code for the Add button? When the two
cbo's BOTH have entries, the Add button should add them to
qryResidentMenu_Match, then requery the form.
I have a continuous form (frmResidentMenu_Match, based on
qryResidentMenu_Match) showing txtResidentName and txtMenuRequest in the
form's detail area. I need to be able to add new rows to this form from
existing lists of residents and menus, so I've put two UNBOUND combo boxes in
the form's header (cboResidentName and cboMenuRequest with row sources
tblResidentName and tblMenuRequest respectively). When the cbo's are filled,
I want to click an ADD button in the header to have the new entry added to
the forms detail section.
a) Is this the correct approach?
b) Can someone help this newbie with code for the Add button? When the two
cbo's BOTH have entries, the Add button should add them to
qryResidentMenu_Match, then requery the form.