How to make form update after selecting value from combo box

M

merry_fay

Hi I have a form with a combo box on it, all the data in the form is from one
table.
The combo box is linked to one column in that table
I'm trying to make it so when I drop down on the combo box & select a value,
only the records with that value show on the form but am at a complete loss.

Do I need to do a Do.Cmd in the afterupdate section or link the text boxes
somehow?

Thanks
 
J

Jackie L

Create a query which uses that combo box as criteria. Base your form off
that query. On the After Update of the combo box put:
Me.Requery

Hope this helps.
 
Top