Re: ComboBox databinding - complex

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

"Mike" <pcgurudeletethis@xxxxxxxxxxxxx> schreef in bericht
news:mAUYg.12240$nn6.5516@xxxxxxxxxxxxxxxxxxxxxxxxx
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



.

Quantcast