Search Function errors... :(

[mateogp]

Hello,

Im trying to create a search form to look up records in the tables. It seems like im pretty close to getting it right, but then I get a debugging error. It says "An expression you entered is the wrong data type for one or more arguments."

Ive been stuck here ever since. Can anyone help me out with this problem?
I would be happy to send you the access database if anyone could offer me any assistance.


Thank you in advance for any help you may be able to provide.


Matt

 

[WayneRyan]

Matt,

Can you remove any unneeded stuff,
Tools --> Database Utilities --> Compact/Repair,
ZIP into a file,
Then attach.

Wayne

 

[mateogp]

Attached File

Wayne,

Ive attached the file.


Thank you for your help and time,

Matt

 

[WayneRyan]

mateogp,

Just played around with it. Experiment with it. Also check out the sample
database forum here for ideas.

Right now, it is an OR search.

Wayne

 

[mateogp]

Thanks so much for your help wayne!


Matt