arunakumari02
Registered User.
- Local time
- Today, 15:22
- Joined
- Jun 2, 2008
- Messages
- 91
I have 5 rows but if I have only 2 rows in record set then I getting an error .
If I have only 2 records in the recordset it gives an error "Syntax error in query expression 'Num = '
Any hints on it.
Code:
For i = 1 to 5
Call change()
Next
CHANGE(i)
Sql = "select * from table where Num= " &forms!frmchange("txtnum" &i)
Set recordset = CurrentDb.OpenRecordset(Sql)
If I have only 2 records in the recordset it gives an error "Syntax error in query expression 'Num = '
Any hints on it.