Cascading Combo Box question

[VeganLiving]

hello, I have 3 cascading combo boxes and I want one of the combo boxes to populate a corresponding value into a text box.
I am putting .cboBox.column(1) into the text box but it doesn't work.
Here is the sql for the combo box.
SELECT DISTINCT NEXTGENERA_V_CMB_METAFIELDS2.DB_COL_NAME, NEXTGENERA_V_CMB_METAFIELDS2.BIZ_NAME, NEXTGENERA_V_CMB_METAFIELDS2.BIZ_DEF, NEXTGENERA_V_CMB_METAFIELDS2.DRVD_IND, NEXTGENERA_V_CMB_METAFIELDS2.BIZ_LOGIC, NEXTGENERA_V_CMB_METAFIELDS2.DB_OBJ_NAME


FROM NEXTGENERA_V_CMB_METAFIELDS2;


Please help I have trying to figure this out the past few days.

[pbaldy]

The syntax is here:

BaldyWeb - Autofill

make sure the column count property of the combo is correct.

[VeganLiving]

Yes the the column counts are correct. I have followed everything on your website(I have it book marked) but it doesn't seem to work. It has worked great in my other forms but when i try to do it in a form that has cascading combo boxes it won't work.

Is there something I should know about .RowSource that could preventing the text box from getting populated.
'this code for cascading combo boxes.' when a schema is chosen the list of tables(cbotablename) in that schema populates


Private Sub ListSchema_AfterUpdate()
Dim strSQL As String


strSQL = "SELECT DISTINCT DB_OBJ_NAME " & _
"FROM NEXTGENERA_V_CMB_METAFIELDS2 " & _
"WHERE DB_SCH = '" & ListSchema.Value & "'"

Me.ListTable.RowSource = strSQL




End Sub

[pbaldy]

Can you post the db here?

[VeganLiving]

No I'm sorry I cannot.

[June7]

Other thread by same poster may be related to this issue https://www.accessforums.net/forms/h...rds-37309.html

[Missinglinq]

...I am putting .cboBox.column(1) into the text box but it doesn't work...

Where/how, exactly, are you attempting to do this?

Linq ;0)>