Access Subform Problem

[Nancy]

I have a large database in a multi-user environment. The database has a main
form with a subform as well. Several times now, someone has gone to open the
database, and the subform has disappeared from the main form. The table with
all the data is still in the database and so is the subform, but when I try
to open the subform by itself I get an error message saying "Type mismatch in
JOIN expression. (Error 3615) A JOIN expression is attempting to join two
tables on fields of incompatible data types. For example, you will get this
error if you attempt to join a Memo field with a Text field." When I check
the join between the two forms though, the join appears to be just fine and
between two of the same types of fields. Can anyone give me any information
as to why this keeps happening? We are able to restore from the back ups, but
what is making this happen in the first place? Any help would be appreciated.

 

[Klatuu]

You may be experiencing some corruption. The corruption could also be in
your backup copy.
I would first try a decompile, then a compact and repair, and then a
compile. If the problem presists, then create a new mdb file and copy all
the objects from the old mdb into the new.

 

[Golfinray]

Start by going to the tables that are the source of the form and the subform,
go to design view and check datatypes. I bet you have two things that are not
correct, such as one field is a date and the other is text, one is text and
the other yes/no, or some other mismatch.

 

[Nancy]

Thanks, I give it a try and keep my fingers crossed.

 

[Nancy]

I'll check that, but for a long time it was working fine and this issue just
started in the last few months. I sure appreciate your input!

 

[Nancy]

I found the compile, but how do I go about decompiling? Thank You!