Combo box and subform issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to have a combo box for selection criteria, to show the
associated records in a subform that is set as a continous form. I want to
show a tabular view of all records filtered by this combo box.

Tx
 
The way I do this is to have another control on the main
form which is linked to the combo box (i.e. the source is
=[ControlName].[column](0) where column(0) is the
matching field for the subform)

Then from the subform link the child and master fields to
this new control.
 
Thanks ACG,

I am not quite sure what you are saying. I want to show multiple patient
records in a continous form on the subform. I need to select by Company name
in combo on main form I guess. I am having trouble visualizing your solution.

ACG said:
The way I do this is to have another control on the main
form which is linked to the combo box (i.e. the source is
=[ControlName].[column](0) where column(0) is the
matching field for the subform)

Then from the subform link the child and master fields to
this new control.
Click to expand...
 
Back
Top