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

Odd error on form "The function you entered cannot be used in this expression..."

P: n/a
I've got a macro on an mde. database that has been working for years.
all of the sudden, my user reports to me that upon execution of the
macro, he gets the error message

"The function you entered cannot be used in this expression.
*You may have used a DoEvents,....."

This macro fires on the after update event of a combo box and simply
creates a purchase order number according to the following.

[Forms]![Frm_InventoryOrderMaster]![DishOrDirect] & "-" &
Format([Forms]![Frm_InventoryOrderMaster]![OrderMade],"mmddyy") & "/"
& [Forms]![Frm_InventoryOrderMaster]![Area]

As I said, this has been working for ages and all of the sudden the
user gets the error.

Secondly, this is not the first time I've seen this error before. A
different user had the same error although she was not using the same
function.

I've read about references and whatnot but they're using an mde.

Any help would be appreciated,

scorpio1769

Jan 31 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.