New Question about Data type mismatch in criteria expression

A

AliceGP

I understand that there's a data type mismatch, and I think I know how to fix
it, if I could just get back to the place to change it.

In order to get to the data type, I usually do the following:

Pull up my form, click on the design view, then open properties, then click
on the data source where the 3 dots (ampersand) are beside the data source
block. This gets me to the area where it looks like a spreadsheet with
criteria possibilities. I then add a criteria, save, close, go back to the
new version of the form and print. Then, I go back and undo the criteria,
save, and close.

NOW...the problem is that once I get that message, I can't go back to the
criteria to change it or see if that's the problem.

Can you help me with this? I hope it's just something I am overlooking...

Thanks!
Alice
 
G

Golfinray

You need to change the datatype in the TABLE that is the source. Go to design
view of the table and change the type. That thing that looks like a
spreadsheet is you query.
 
Top