rowsource problem 2

[vfpgolfer]

I have a program where I create a cursor readwrite then put into a combo as follows:
WITH THISFORM.esipageframe1.draft
.combomajorclfilter.STYLE=2
.combolawyerfilter.ROWSOURCETYPE=6
.combolawyerfilter.ROWSOURCE="sellawf.id,initials"
.combolawyerfilter.LISTINDEX=.combolawyerfilter.LISTCOUNT
.combolawyerfilter.REFRESH()
ENDWITH

later in the program I refresh the combo (in case of changes) by redoing the select into the cursor then re-executing the above code.

I get error cannot access the selected table

I put brow after the select and wait window after the .rowsource to verfiy where it was happening - is it necessary to clear the combo first? (.rowsource="" etc.?

 

[craigsboyd]

Yes.

SweetPotato Software Website
My Blog

 

[Mike Lewis]

Vfpgolfer,

This is a documented behaviour.

From the Help for Error 1152:

This error can occur under the following conditions:

A table or cursor that is specified for the RowSource property of a ComboBox or ListBox control is closed.

If you want to close a table or cursor that is specified for the RowSource property of a ComboBox or ListBox control, perform either of the following actions prior to closing the table or cursor:

Set the RowSource property to an empty value ("").
-OR-
Release the form containing the ComboBox or ListBox control.

Hope that helps.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[vfpgolfer]

Thanks guys - I put that (rowsource="") before the new second select and no more errors.

Help from two of the best is always appreciated.