Linking Two Combo Boxes

[Cain24]

Hey,

I'm pretty new to this, so I appreciate any help you guys can give me.

I have one combo box that gets it's data from a database in MS Access. What I want to happen is that when, say, item A is picked in that first combo box then combo box #2 gets updated with database A. When item B gets picked, then combo box 2 updates with database B, and so on... Any help would be great.

Thanks

 

[SkipVought]

Hi,

What application are you programming in?

How are you accessing the MS Access db?

What are database A & database B? Both MS Access?

The short answer is, the selection from combobox 1 is used as the criteria for the second query linked to combobox 2.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Cain24]

Hey Skip,

I'm using Visual Basic 2008 Express Edition and both A and B are Access databases. The databases are accessed by binding them as a DataSource. This isn't working when I want to do multiple databases to one combo box, I guess you can only bind one database to one combo box.

Thanks.

 

[SkipVought]

Visual Basic 2008 Express Edition

This forum is VBA for Applications like Excel, Word, Outlook, Powerpoint. You ought to be posting in some other forum.

This isn't working when I want to do multiple databases to one combo box

You must has 2 separate connection objects and open 2 separate recordset objects. Then join the data programatically. If it were Excel, I'd return the data to two separate sheets and then run a UNION query.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

Are you trying to get the Oil Filter values?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}