Update one field w/ the unbound column of a list box of another field 1

[ajarantes]

I have a form with fields City and State.

The user choose the City from a list box that shows 2 collumns, City and State. I can have the same City in different states, so City can appear more than once. Of course, I want the user to choose the City from the correct State.

The bound column is City but I also want that the system update the second field - State, with the unbound column of the list box.

Am I clear? Is it possible? Does anybody knows how?

 

[Rolliee]

I just created a table with three fields, an autonumber and two others. Populating the listbox with the two tables and the followiing code, allows me to see both values. You must use the click event of the list box to catch the values.


Private Sub List3_Click()
MsgBox " col 1 " & Me.List3.Column(1)
MsgBox " col 2 " & Me.List3.Column(2)
End Sub


Remember, if these tips help click the 'Mark this post as helpful...


rollie@bwsys.net