Generate Value for Text Box Based on Forms Underlying Recordsource (Query)

[McArthurGDM]

Hi,

I have 3 forms: Main -> Subform1 -> Subform2 (a subform of 1).

Subform2's Recordsource is a Query. On Subform2, I have unbound combo boxes. The query criteria seeks the values of those combo boxes using this

[forms]![Main]![Subform1].[Form]![Subform2].[Form]![Control]

I have a Command Button on Subform2 that refreshes everything (sendkeys F9) and then makes a TextBox visible. This TextBox should show some value given the underlying query. However, the only value that I get back is usually always the first value in that query (sometimes nothing).

Can you set a forms underlying RecordSource to a dynamically change query?

[June7]

Yes. This is one technique to dynamically filter a form's RecordSource. However, I have never used dynamic parameterized queries. I've never needed to filter a subform beyond what is accomplished by the Master/Child Links properties.

[McArthurGDM]

How do you refresh that forms recordsource based on those parameters? I dont think sendkeys F9 is working.

[June7]

Maybe with VBA:

[forms]![Main]![Subform1].[Form]![Subform2].Requery