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
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