Data type mismatch

  • Thread starter Thread starter Bob Love
  • Start date Start date
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.
 
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]...
 
Back
Top