ComboBox databinding - complex

[Mike]

I have three tables. TableA and TableB contain data related via TableC (a
many to many relationship).

I would like to use a ComboBox to allow a user to choose the TableB entry
for TableA. Ideally, the data in TableB would appear in a sorted fashion in
the ComboBox. I would also like the user to be able to enter text that is
not in the ComboBox list, if desired. Other data will be entered on this
form as well. The user will press a button to signify that they are finished
modifying data.

When the user presses this button, I need magic to occur that will create
the proper rows in the three tables as a result of the text in the ComboBox
(the rest of the data is databound).

I know this can be done - its just that my small mind hasn't stumbled across
the correct method as yet. Please help.

Thank you very much.

Mike

Access 2003/VB 2005 Express Edition

 

[Cor Ligthert [MVP]]

Mike,

It is not a combobox and not 3 but see this sample.

http://www.vb-tips.com/dbPages.aspx?ID=1528d312-af64-4983-90b2-d663cbcccb64

I hope this helps,

Cor