"Too few parameters" in an OpenRecordSet

[Sullaway]

Hello Tek-Tippers,

I'm having problems getting this error fixed. I have been reading books, past post, & etc. for about 3 hours now. I have found a lot of information on it but just can't seem to fix my problem.

I'm trying to pull infomation from Table Customers and update the Address fields in Guardian, if the CustomersID (number) matches. Below is the line of code that keeps puking.

strSQL = "SELECT [CustomersID],[Address] FROM Customers WHERE Customers.CustomersID=[Forms]![frmGuardian]![CustomersID]"
Set rst = dbs.OpenRecordset(strSQL)

It keeps telling me "Too few parameters. Expect 1". If I take the WHERE clause out the field will update but the info is from the first record so I know my problem is in the WHERE portion but no matter how many different syntax combinations that I've tried I can't see to get it to quit puking.

Any help would be greatly appreciated.
Shane

 

[tlbroadbent]

You need to allow the VBA code to interpret the contents of the control, [Forms]![frmGuardian]![CustomersID]. Move the control outside of the quotes.

strSQL = "SELECT [CustomersID],[Address] FROM Customers WHERE Customers.CustomersID=" & [Forms]![frmGuardian]![CustomersID] Terry Broadbent

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[Sullaway]

Terry,

Thanks for the help. It almost always turns out to be something simple.

Shane