By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,720 Members | 2,096 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,720 IT Pros & Developers. It's quick & easy.

Startup Form causes query to prompt for parameter

P: n/a
Hi All,

Access 2000 SR1
Windows XP SP2
Word 2000

I have a button on a form (frmMainMenu) that calls a second form
(frmContractPrint). In the second form is a combo box
(cboContractNumber) and the user selects a contract number from the
list. The combo box list is used in a query, which in turn is used to
create a Word mail merge. The Mail Merge is done in VBA. This all
works fine until I set frmMainMenu to be the startup form. At this
point, the forms work fine but when Word starts to initiate the DDE
link I get the standard dialog asking to set the parameter value. It is
asking for the value that the user chose in the combo box above. ie
Forms!frmContractPrint.cboContractNumber

As I said, the above works fine in testing and only displays this
behaviour when I set the frmMainMenu as the startup form. No other
settings have been changed in the startup dialog box.

Any help would be much appreciated.

Regards

Glyn Baker

Jul 28 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a

Glyn wrote:
Hi All,

Access 2000 SR1
Windows XP SP2
Word 2000
Do you have any objects on your startup form that query any tables?
(like comboboxes or is the form bound). Other than that, I can't think
of anything. I'd patch A2K. The only worse piece of software MS put
out seems to have been A95.

Jul 29 '06 #2

P: n/a
Hi,

The startup form just has a series of buttons that users click to call
up other forms, run reports etc. The one that is causing the problem
opens a second form that has a combobox which lists the contract
numbers. This is by way of a query. The selected contract number from
the combobox is used as the criteria in another query which is used in
the mail merge.

In the meantime I will patch up to the latest Office 2000 patches.

Glyn

Jul 31 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.