M
mchd
All thing is the title,
Thanks for any help
Thanks for any help
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bas Cost Budde
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
But your users don't need to see what you do. See Help for docmd.echo
M
mchd
I thought it was obvious that i wanted to solve the probleme by code.
B
Bas Cost Budde
mchd said:I thought it was obvious that i wanted to solve the probleme by code.
Yes, I thought so too.
docmd.openform yourformname, acdesign
forms!yourformname.recordsource=yoursource
docmd.close acform, yourformname, acsaveyes
C
ckerns
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.
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.