Help!!! Using AfterUpdate Event (1 Viewer)

[Data Slave]

I need to update two combo boxes by selecting something in another combo box. I know how to use afterupdate to do this for one combo box to another, but i can't get it for two! Here's the way I do it already for the combo box I have the info in:
Me.combo2=Me.combo1.column(1)

do i just need to add another statement with a different column number? what does the column number reference? the table or the query it's based on? please help. i've been messing with this for hours.

 

[bobjames]

the column number refers to the column of fields with in the recordsource of the combo box itself. For example if the combo box's recordsource was a table called "Table1" and Table1 had 3 fields the Combo1.column(0) would be the 1st field in the table and Combo1.column(1) would be the 2nd field in Table1.

What I think you need to do is add another line of code to the event that be like this

Me.combo3=Me.combo1.column(1)

assuming Combo3 is the name of the 3rd combo box and you want to set it equal to the value of the 2nd column of Combo1.


[This message has been edited by bobjames (edited 08-08-2000).]