Help setting up a form properly

[cinnie]

Hello gurus

I have a form (frmStudent-DinnerPlan) bound to qryStudent-DinnerPlan. The
form has two comboboxes (cboStudentNumber with row source tblStudentNumber,
and cboDinnerPlanNumber with row source tblDinnerPlanNumber. I want the form
to also have a subform that shows all values in qryStudent-DinnerPlan. The 2
comboboxes will then be used to add new rows to the query.

Oh ya - I can't have allow StudentNumber - DinnerPlan combinations in the
query.

 

[Bob L.]

cinnie,
Not clear why you want that. Subforms are usually linked to records in
the main form.
Why not just a form in Add/edit mode with the 2 combo boxes
bound to the appropriate fields in the query? The user can see all of
the records and can then add records using the record indicator box.
Another option might be a single form bound to the query showing all of
the records with unbound combo boxes in the header and then some code to
do the append you want to do after clicking on a command button, etc.

Bob L.