>This may not solve the problem but I always change the RowSourceType to 0 and then back to it's original setting if I'm doing anything with the RowSource.
>
>>Hi,
>>
>>Intermittently, I am getting error number 10, syntax error on the last line of the following code:
>> thisform.cboReport.RowSource = ''
>> CREATE CURSOR AvailableReports (cLine C(20))
>> INSERT INTO AvailableReports (cLine) VALUES ('Generic Query')
>> INSERT INTO AvailableReports (cLine) VALUES ('GL Activity')
>> thisform.cboReport.RowSource = 'AvailableReports.cLine'
>>
>>I can see the problem is my redefining of the cursor behind the combo box. But I have not been able to see a pattern of when I get this error, as I can go thru it many times before hitting an error.
>>
>>Can anyone suggest what I might do differently?
>>
>>Thanks!
Thanks Nigel, I will give that a try!
Cheers,
Vern