Expression Error

[Tari]

I have a form where users enter supplier information.. Name, Address, Contact, Phone etc. etc.

I have 6 databases for 6 departments and 2 of them entered something into the supplier information that access does not like, as I get the attached error. The other 4 are fine.



Looking at the table that contains the supplier information, I can't find anything that looks funny.

Any idea how I can narrow down where this error comes from?

Thanks!

[ssanfu]

OK, trouble shooting questions:

* For the two "bad" databases, does the error happen in the same form/report/...? At the same point?

* Could there be a calculated control on the form/report?

* If the record source for the form/report is a query, open the query. Do you get the error??

* If the error is in a query, create a copy of the query, then in design view, delete one column at a time until the query executes without an error. The last column you deleted is the problem.

* Are the databases split, with the BE on the server and a *copy* (not shortcut) on each user's computer?

* If the databases are identical, make a copy of one of the "good" front ends and link it to one of the "bad" back ends. Is there still an error??

[Tari]

Sorry I should've clarified

There are 2 buttons that open 2 forms in which users put supplier information. When you hit the button the error occurs, you hit OK and the form opens without any problems.

The button calls a macro. The macro simply opens the form, one in "add" on in "edit" mode.

I imported the forms from a working database, but it makes no difference. I imported the macro from a working database and it makes no difference either.

Therefore I was thinking that I might have something to do with the data the users entered into the supplier information forms, but I found no symbols, spaces or anything out of the ordinary.

[ssanfu]

That is the problem with macros: no error handling. I never use them.

So if you use the database window and open a form, do you get the error??

What commands are in the macro?

What about the rest on my questions. Its hard to help you troubleshoot without info.

[Tari]

I'm quiet the noob and macros are fairly easy

I shall answer all your questions when I'm back at work tomorrow. I wouldn't know without looking at the DB )