Referring to a control on a form in a SQL SELECT string

  • Thread starter Thread starter JimP
  • Start date Start date
J

JimP

The following statement is generating a 3061 error - too few parameters. How
do I refer to a control on a form? e.g.

strSQL="SELECT OrderID from Orders WHERE OrderID = Forms!Form1!OrderSel;"
 
The following statement is generating a 3061 error - too few parameters. How
do I refer to a control on a form? e.g.

strSQL="SELECT OrderID from Orders WHERE OrderID = Forms!Form1!OrderSel;"
Click to expand...

If OrderID is a Number datatype field, then:
strSQL="SELECT OrderID from Orders WHERE OrderID = " &
Forms!Form1!OrderSel

If OrderID is a Text datatype field, use:
strSQL="SELECT OrderID from Orders WHERE OrderID = '" &
Forms!Form1!OrderSel & "'"
 
Back
Top