Open form with 3 Criteria

D

DS

I'm trying to open a form with 3 criteria, only the LineID seems to take.
Any help appreciated.
Thanks
DS

DoCmd.OpenForm "MemoPad", acNormal, "", "LineID=
Forms!CheckEdit!TxtLineID " & _
"And SalesID = Forms!CheckEdit!TxtSalesID " & _
"And ItemID" = Forms!CheckEdit!TxtItemID, , acNormal
 
F

fredg

I'm trying to open a form with 3 criteria, only the LineID seems to take.
Any help appreciated.
Thanks
DS

DoCmd.OpenForm "MemoPad", acNormal, "", "LineID=
Forms!CheckEdit!TxtLineID " & _
"And SalesID = Forms!CheckEdit!TxtSalesID " & _
"And ItemID" = Forms!CheckEdit!TxtItemID, , acNormal
Click to expand...

Is this code on the CheckEdit form?
I'm guessing that all of the 3 criteria fields are Number datatype:

DoCmd.OpenForm "MemoPad", acNormal, , "LineID= " &
Me!TxtLineID & " And SalesID = " & Me!TxtSalesID & " And ItemID =
" & Me!TxtItemID
 
D

DS

fredg said:
Is this code on the CheckEdit form?
I'm guessing that all of the 3 criteria fields are Number datatype:

DoCmd.OpenForm "MemoPad", acNormal, , "LineID= " &
Me!TxtLineID & " And SalesID = " & Me!TxtSalesID & " And ItemID =
" & Me!TxtItemID
Click to expand...
Yes it is on the CheckEdit form and all there are of numeric persuasion!
Thanks, it works!
DS
 
Top