How to link subform with the Combo Box

[rbasram]

Hi

I have a combo box on the form and there are some values what I am trying to do is I want to select an item in the combo box and then the other fields relative to that selected item should be shown in the subform.

I want to pass the selected value from the combo box through the query and get the result in the subform.

Is there any simple way of doing it...

 

[Databaseguy]

The combo box should be unbound. (However, it could still get it's record source from a table or query).

Put a command button on the form. It will have a very simple statement. Me.Refresh

In the query that controls the sub-form (if you don't have one, make one) enter a field that you want the combo to search by. In it's criteria, enter: [forms].[youformnamewithcombobox].[yourcomboboxname]

Make sure that the field that you want to search on is the first field in the combo box. (Default) Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy