how to change the source of a closed form ?

  • Thread starter Thread starter mchd
  • Start date Start date
You have to have it open in design view to do this.

But your users don't need to see what you do. See Help for docmd.echo
 
mchd said:
I thought it was obvious that i wanted to solve the probleme by code.
Click to expand...

Yes, I thought so too.

docmd.openform yourformname, acdesign
forms!yourformname.recordsource=yoursource
docmd.close acform, yourformname, acsaveyes
 
In form to be opened, leave RecordSource empty.

In the event that calls the form to be opened, after the open call
insert a line that says something like:

Forms!frmMyFormName!RecordSource = "qryMyQuery"

I can't remember if you need the quotes, if this doesn't work, try
removing them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Opening form unexpectedly closes other form 0
Access Form Refresh 1
The next Grand Theft Auto title has been officially announced 0
Form shows ID, not values 1
Change Record Source of a Form - Twist 2
Split Form Not Honoring Select Statement 1
Access Sub form opens before the main form in MS Access 0
Minimise, Restaure, Close 4

Back
Top