Error 2447 and VB Dates

[Fubear]

I have a database i wrote and has gone live. I am getting reports of it crashing and groing to the debugger.

I get the error message 2447, which is "Invalid . operator, ! operator, or invalid parenthasis.

The line of code it breaks on is:
dateToday = DateBox.Value

Full code for the function section is:
Dim dateToday As Date
dateToday = DateBox.Value

DateBox is an invisible textbox on a form with the default value of Date().

---
I'm told it worked before I last updated it. Although my update didnt touch that section of cade that worked fine before.

I am unable to reproduce the error on my machine here, and dont know how to start on fixing this error.

 

[Fubear]

as an update - I told the problem is in every form that uses this code. My last update only changed one form.

Could this be an Access config issue?
I use access through a "remote login" to a central server, and so far the only complaints are form those who have access on their local computer or laptop.

 

[cmmrfrds]

If it worked before the change then it is probably not a configuration issue unless you somehow changed the configuration. I suspect it is a control flow issue. Go back and see how your new code could cause the problem. Maybe the control DateBox is disabled through some logic you put in.

 

[Fubear]

I added an unrelated field on one form, I restored my backup and all is happy in the office again. Have to be al ittle more careful in my testing before putting a new version live.

Luckily it was only a small cosmetic change that was implemented since the last backup.