too few parameter, expected 1

[stingers]

whats wrogn with this code??? continue to get error listed in subject?? Making me crazy

refID is a text field

Set rst = CurrentDb.OpenRecordset("SELECT dbo_tblREF.* FROM dbo_tblREF WHERE (((dbo_tblREF.RefID)= col28));&quot

thanks in advance

ryan paul

 

[RickSpr]

What is col28? Most likely, SQL isn't recognizing that name, and is treating it as a parameter. Rick Sprague

 

[JoyInOK]

If ColID is the actual text in the field, you'll need quotes around it. Use single quotes when writing SQL in code.
(dbo_tblREF.RefID)= 'col28'

 

[Taff07]

It depends on the field type on what surrounds the value. For a text string itll be as you say quotes, I fits numeric its fine on it`s own but if it`s a date it needs the # symbols either side of the value.

I`ll agree though that this may be the reason for the error in this case if my memory serves me correctly.

Ian

 

[stingers]

***UPDATE TO ORIGINAL POST*****

HERE IS ALL THE CODE


Dim strStatus As String
Dim strMsg As String
Dim rst As Recordset


strStatus = Me.cboStatus

Set rst = CurrentDb.OpenRecordset("SELECT dbo_tblREF.* FROM dbo_tblREF WHERE (((dbo_tblREF.RefID)= " & strStatus & ";&quot


as an example strStatus could be Col28. I have tried to put single quotes (') inside the double quoted part of the select statement. The error i get is

Run Time error '3075'

Syntax Error in query expression '(((dbo_tblREF.RefID)='col28';'

or

Syntax Error in query expression '(((dbo_tblREF.RefID)=col28;'


thanks in advance

 

[RickSpr]

You need the single quotes. You also have unbalanced parentheses. Rick Sprague

 

[Taff07]

Try this SQL. Added the ' marks eithier side of the strStatus plus addded adjusted the () to balance i think.

----------------------------------------------
Set rst = CurrentDb.OpenRecordset("SELECT dbo_tblREF.* FROM dbo_tblREF WHERE (((dbo_tblREF.RefID)= '" & strStatus & "'))&quot
----------------------------------------------

Hope this works

Ian