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

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;"
 
F

fredg

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 & "'"
 

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

Run-time error 3061. Too Few Parameters. Expected 2. 2
Recordset within a recordset? 5
Problem trying to open a recordset 5
Error 3061 - too few parameters 2
DoCmd.OpenForm 4
Creating a querydef of a stored proc on Sql Server 8
SQL Select Statement passing value from a form 1
result from sql query in recordset 3

Top