Switch Recordsource with VBA without writing an SQL statement

[Lockrin]

I have a form that I want to be able to run from several different queries at different times. I want to have buttons on another form to open this form and select the recordsource. I do not know how to write SQL, so if it is possible to change the recordsource of the form without writing an SQL statement that would be super.

[pbaldy]

You can set the source to the name of a saved query.

[Lockrin]

You can set the source to the name of a saved query.

That's good news. Can you give me the VBA code to implement this?

[pbaldy]

There are examples in VBA help on "recordsource".

[Lockrin]

Thank you for what help you gave me, however I cannot find any threads on this topic nor can I find the section "VBA help".............. got a link to the thread?

[pbaldy]

I meant using Help within the VBA editor program. Here's an example from it:

Forms!frmCustomers.RecordSource = "Customers"

[Lockrin]

That's it! Thanks a lot sir