Combo box loading from multiple tables 1

[DMSReed]

I need to load a combo box from a predefined table (RowSourceType=6). The table to use for the RowSource property will be based on a previously selected item from a prior combo box. If combo2.value='B' then RowSource=B, otherwise RowSource=A. (Both RowSources A and B are pre-established tables).

I have tried various things based on earlier threads but have encountered various errors. Below i sthe code I used in the GotFocus event of the Combo box, but I received an "Unknown member" error with "RowSource" being the indicated problem.


IF THISFORM.combo2.VALUE='PRINTER'
SELECT * FROM auditp INTO CURSOR myc
ELSE
SELECT * FROM auditm INTO CURSOR myc
ENDIF
This.RowSource.value="myc"

Thanks in advance!

 

[andrewlee]

DMSReed,

The last line should probably read
This.Rowsource = "myc"

Andy

 

[DMSReed]

Thanks Andy!
Worked exactly as I hoped.

DMSReed (Scott)