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

Add Duplicate Record with blank combo box

P: n/a
Hello. I have a data entry form with several combo box fields with
dlookup code in the after update procedure for the field. I am trying
to add a button to copy the record on this form. I am running into a
problem when one of the combo box fields with the dlookup procdeure is
blank. I receive the following error.

Run-time error 3075: Syntax error (missing operator)

If I hit "end", it copies the record but I would like to suppress this
error message.

The code on the duplicate record button is:

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdPasteAppend
Any help would be appreciated.

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
? SetWarnings False ???

c.kurutz wrote:
Hello. I have a data entry form with several combo box fields with
dlookup code in the after update procedure for the field. I am trying
to add a button to copy the record on this form. I am running into a
problem when one of the combo box fields with the dlookup procdeure is
blank. I receive the following error.

Run-time error 3075: Syntax error (missing operator)

If I hit "end", it copies the record but I would like to suppress this
error message.

The code on the duplicate record button is:

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdPasteAppend
Any help would be appreciated.

Nov 13 '05 #2

P: n/a
Thank you for your reply. I have tried that option. It doesn't work.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.