Open form with 3 Criteria

  • Thread starter Thread starter DS
  • Start date Start date
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
 
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
 
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
 

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

Similar Threads

Loop Question 2
No Records Then 4
SQL Syntax Problem 2
Finding Records 7
Loop Returning One Value 6
Open Form Problem 5
Open a record on a form depending on the record of another form 5
Where In Wrong Place 2

Back
Top