Access Query Help

[jimfrmla]

I need to create a query in access from a combo box that allows me to poplulate the entire form once a value is selected from the pull down list. This form is actually a subform. Any suggestions would be greatly apprieciated.

Thanks

 

[OnTheFly]

You can do this in a couple of ways.

1. Get the criteria from the combo box and then apply a filter to the sub form. Make sure you use both the Filter property and the FilterOn=True.

2. You can create a query using the combo box criteria and change the RecordSource property of the sub form to that query.

Hope this helps.

OnTheFly