How does a record source query identify the key, when the SQL is calling the table and not the form

[CoffeeFunnel]

Hi All,



Basic question, how does a record source query identify the key, when the SQL is calling the table and not the form?

The query is a record source of a subform, and the primary form's record source is another query that does have the key that is used in the subform's query. I thought you had to reference the form object in a query in order to pass the key value over to the query?

Can someone walk me through this?

Cheers,
CoffeeFunnel

[June7]

Are you asking about how a form/subform arrangement synchronizes the main and sub form records? The Master/Child Links properties of the subform/subreport container control manage this.

[CoffeeFunnel]

There isn't a Master/Child Links properties in the main form and subform. I don't know if this matters, but the main form and sub form are using filters.

[June7]

What do you mean there 'isn't a Master/Child Links properties'? You mean you haven't set those properties? Why not? Do the main and sub form data sources have a dependent relationship?

Post the SQL statements of each RecordSource.

If you want to provide db for analysis, follow instructions at bottom of my post.

[CoffeeFunnel]

There just not there. My recordset type is Dynaset. But, I'm okay; I figured out a workaround for what I needed to do. I'm not sure how it's all working out internally, but I'm just updating the query definitions to pass form values into my SQL statement. It's much easier for me to work with SQL then with the form properties and stuff.

Thanks for your help and time.

Cheers,
CoffeeFunnel

[June7]

I'm glad you found a solution, however, your statements make no sense to me.

The Master/Child Links are properties of the subform container control, not the form.

Exactly how are you 'updating the query definitions'? The purpose is to synchronize the related records? This sounds more complicated than just setting Master/Child Links.

[CoffeeFunnel]

Hi,

Sorry for the delay. Yes, you are correct. I found the Master/Child Link properties in the subform container control. They are blank, the source object is a query. I am working directly with the query definitions. Rather then through the MS access interface options. I just find this easier. Thank you again for the time.

Thanks!
Funnel + Coffee = Me