Linking combo boxes to tables

[PiCubed]

I'm trying to create a form that uses combo boxes to select a table and then from that table I need to create linked combo boxes that searches for information. The first combo selects the table the second combo says I want this record the next combo says I want this column from this record and then save this information to a separate table. I'm not sure if it's possible to create a parameter query that would find the table or if there is another way to have the combo box find it. Once it is found how to get the combo boxes to find the correct cells.


I'm familiar with Access, just not VB and I'm fairly confident I will need VB to do this.

Any ideas? PiCubed

[vb5prgrmr]

If you are using DAO you will need a tabledef. If ADO you will need a reference to ADOX and then it would be time to use your friends (yahoo, google, ask, answers, bing) to search for vb6 ADOX tutorial...

[PiCubed]

I'm trying to create a form that uses combo boxes to select a table and then from that table I need to create linked combo boxes that searches for information. The first combo selects the table the second combo says I want this record the next combo says I want this column from this record and then save this information to a separate table. I'm not sure if it's possible to create a parameter query that would find the table or if there is another way to have the combo box find it. Once it is found how to get the combo boxes to find the correct cells.


I'm familiar with Access, just not VB and I'm fairly confident I will need VB to do this.

Any ideas? PiCubed

I don't know what DAO or ADO are...

I've written the code so a table can be selected from the Navigation pane, but now I need to link the next combo box to the first selection.