ComboBox Syntax for Access 97

[databasesrus]

I am working with Access 97 and havent' in a long time. I can't remember the wording to have the combo box selection populate the text box. It is something like

If Not IsNull(combo10) Then text1.value = combo10.column(2)

But this is off somehow because it is debugging every time i try this. Can someone please refresh my failing memory?

Thank you!

 

[nfell]

Hi,

I created a combo box linked to a table with 2 fields in it and a text box. This code worked for me -

If Not IsNull(Me.Combo10) Then Me.Text1.Value = Me.Combo10.Column(1)

Column(1) being the second field Column(0) being the first.

Hope this helps.

 

[databasesrus]

Thank you. I guess I forgot the me! Thank you so much!