Data type mismatch

B

Bob Love

I have a form in datasheet view (summary of work orders) based upon a query
of summary of work orders. On the Equipment ID control I want to double
click and have the equipment for open to the equipment listed on the summary
of work orders form. My macro where condition is writtten as ="[Equipment
ID] =" & [Equipment ID] but Im getting a data type mismatch. I've used the
basic syntax before and it works fine but I can't seem to find the problem.
 
B

Bob Love

Darn it. I got it to work. Reading the help file. the final syntax for
anyone concerned is [Equipment ID] = [Forms]![Summary of Orders]![Equipment
ID]...
 

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

Top