To get SQL of loaded recordset (not recordsource)

[mercapto]

Hello

I need to take the SQL of a loaded recordset to use it later.

I usually take Recordsource, but this time the form refers to a query with input parameters. So it's not only the query name, or the sql of it, it's the WHERE that changes everytime.

So how can I get this after-input SQL sentence??

[June7]

Suggest not using input parameters in query. I very seldom do.

I use the WHERE CONDITION of OpenForm/OpenReport, something like:

DoCmd.OpenForm "form name", , , "ID=" & Me.ID.

Now can pull strings from not only the RecordSource but also Filter properties of form.

[mercapto]

Suggest not using input parameters in query. I very seldom do.

I use the WHERE CONDITION of OpenForm/OpenReport, something like:

DoCmd.OpenForm "form name", , , "ID=" & Me.ID.

Now can pull strings from not only the RecordSource but also Filter properties of form.

Ok, so I understand it's not possible. Thanks for the tip, indeed.

I finally built the sql "manually" by using the data in the form. Maybe it's better this way because it's a shorter string.

I will soon change the opening method for the form. When I started my db I didn't know any VBA so I used queries for everything.

Thanks.