Type mismatch in JOIN expression. (Error 3615)

  • Thread starter Thread starter Charlotte Hinger
  • Start date Start date
C

Charlotte Hinger

I can't open a form that worked previously. I don't know where to find the
problem. This form is for non-fiction books, with a drop-down box for authors
names. There's another quotation form that accesses a variety of sources
through a union query. Where do I start looking for the problem? In the form
design, the table or the union query?

Charlotte Hinger
 
I don't know how it happened, but a data type mismatch is almost always
caused by something not in a proper field. You have a date in a number field.
A number in a date field. A number in a text field, ETC
Milton Purdy
ACCESS
State of Arkansas
 
OK. Thanks. Let me try to trace that.

golfinray said:
I don't know how it happened, but a data type mismatch is almost always
caused by something not in a proper field. You have a date in a number field.
A number in a date field. A number in a text field, ETC
Milton Purdy
ACCESS
State of Arkansas
Click to expand...
 
Back
Top