I want to pass a variable when I double click on a form to open another form.
Line item number is a auto number with long integer on one table.
On the second table it is number with long integer.
When I created the double click event when I am on line item number
Private Sub line_item_number_DblClick(Cancel As Integer)
DoCmd.OpenForm "TBLservicelinedetails", WhereCondition:=" [line item number] = '" & Me.[line item number] & "'"
Run time error 3464
Data type Mismatch in criteria expression....