Using an unbound combo box

  • Thread starter Thread starter Nancy Conrad
  • Start date Start date
N

Nancy Conrad

I have a form with three subforms, after selecting a value in an
unbound combo box on the form. I would like to be able to find the
first record where the value is listed in the table and then of course
all of the subforms would follow. I would appreciate any help.
Thanks
 
Put the unbound combo box on the main form in the form
header. Use the wizard to create the combo box and select
the option to find records. If subforms are properly
linked to your subform, the related data will appear in
each of them.
 
If the RecordSource of the MainForm is a Table or a Query
where your "first Record" comes through, you should be
able to use the ComboBox Wizard to create this "search"
ComboBox. In the first CBO Wizard dialog, select "Find a
Record on my Form that matches ..." (something like that,
anyway).

HTH
Van T. Dinh
MVP (Access)
 
Back
Top