Re: Auto populate a form
Create an unbound main form to hold the selection criteria and a bound subform in DS view to display the selection.
The RecordSource for the subform should be a query with a WHERE clause that references the combo on the main form.
WHERE ClassID = Forms!yourformname!cboClassID
If there is only one criteria, then in the AfterUpdate event of the combo, requery the subform.
If there are multiple criteria, use a button to requery the subform.
Bridge Players Still Know All the Tricks