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