Don't you
need to place the name of the query in quotes as well? I think you
do.
You should
also turn off notification, (application.notify = false) otherwise your users
will be asked if they want to create the table each time the form
opens.
Oh, the
notify bit was ottomh so you might need to tweak it a bit.
-----Original Message-----I have a form that gets its objects from a query. The form is opened
From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of torres0157
Sent: Friday, October 14, 2005 10:24
To: AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers] Macro question:
Importance: Low
when the user click on a button 'Commission' and an event procedure is
executed Docmd.OpenForm. The problem I am having is that I also need a
a make table query executed before the form is Opened. I tried this
code but it was incorrect. Can someone Help...
stDocName = "Prescreen_Commission_Form"
DoCmd.OpenQuery Qry_Prescreen_Commissions_Make_Tbl
DoCmd.OpenForm stDocName, , , stLinkCriteria
Thanks,
A.T.
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
