Updating subform based on 2 criteria from main form

[kurazy]

I have a query that runs based on 2 criteria. I have a form with a subform that is based on the query. I want to update/display/run the query in the subform based on the selections of the controls in the main form.

When I make my selections the subform stay blank

Please help

Thx

[June7]

The query uses INNER JOIN - should be RIGHT JOIN.

The comboboxes have BoundColumn set to 2 and should be 1.

Then you need code to Requery the subform after selections in comboboxes or click Refresh All from the ribbon.

I would use a single form set to Continuous View so the comboboxes could be in the same form as the data. Controls can be arranged in Continuous View to look like Datasheet.

I never use dynamic parameterized queries. I use VBA to set form Filter property.

[kurazy]

I have to admit I am a bit of a noob when it comes to access. I didn't write the sql, I used the query design and I don't know vba. So I am a bit lost.

[June7]

Specifically what do you not understand about the instructions already given?

Use the query builder to modify the links between tables in the query.

Have you studied an introductory reference to learn basics?

[kurazy]

Aha. I think I got it. Thanks. I didn't read your first reply properly. Bad habit, my bad