>Hi timothy,
>
>>Is it good practice to have a combobox's rowsourcetype set to fields when the rowsource is a cursor? I am getting cannot "access selected table" frequently and thought this may be a possible cause.
>
>Well it is a good practice. However when doing a
SELECT ... FROM .... INTO CURSOR MyCursorBoundToCombo
, you might get this specific error as for one moment the cursor is closed and recreated again. To workarround the issue
>
>
THISFORM.MyComboBox.Rowsource = ""
>SELECT ... FROM .... INTO CURSOR MyCursorBoundToCombo
>THISFORM.MyComboBox.RowSource = "MyCursorBoundToCombo.Field1, Field2"
>
>HTH
>
Walter, That is basically what I have:
thisform.mycombobox4.rowsource=''
select * from office3 into cursor whichoff where not 'BO' $ office order by office nofilter
thisform.mycombobox4.rowsource='whichoff'
thisform.mycombobox4.selected(1)=.t.
Must be some other cause to why I get that pesky message.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."