Multiple Databindings

[Rinoa]

Is it possible to change the data binding of an object depending on what a user has selected from a list?

For instance:

I have a list with table names(minus the tbl prefix, I use Hungarian notation)

Sold
New
Used


The user selects a table and when the selection changes I want all the objects on the page to be bound to the newly selected table. Help?

[VBPhilly]

Is it possible to change the data binding of an object depending on what a user has selected from a list?

For instance:

I have a list with table names(minus the tbl prefix, I use Hungarian notation)

Sold
New
Used


The user selects a table and when the selection changes I want all the objects on the page to be bound to the newly selected table. Help?

Yes, it can be done.

You should code the rebinding in the click or change events of the listbox.

What kind of data access are you working with?

[Rinoa]

Thanks, and I'm working with a microsoft access 03 database.

Could you give an example of the code, or link a tutorial? I haven't been able to find a good one for this.

[VBPhilly]

Thanks, and I'm working with a microsoft access 03 database.

Could you give an example of the code, or link a tutorial? I haven't been able to find a good one for this.

How are your controls currently bound?
DataSource,
Datamember.