Type mismatch in JOIN expression. (Error 3615)

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
 
G

golfinray

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
 
C

Charlotte Hinger

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Type mismatch in expression. (Error 3615 4
Error 3615 5
Type mismatch in JOIN expression. (Error 3615) Join data stored asText and Number 4
Error: Compile Error,ByRef argument type mismatch 0
Data type mismatch in criteria expression 1
Data Mismatch in Excel 2010 4
Type Mismatch in Join Expression - A little help 2
Form error "Type Mismatch" 2

Top