Toggle Data Source for Tabbed Form 1

[larrydavid]

Hello,

I have a tabbed form (4 tabs) which has an Access query comprised of three joined SQL Server 2000 (linked) tables as the data source for the UI controls on all tabs.

Is it possible to have a combo box on the first tab (form) that can select a different query as the data source, thus populating the UI controls with its data?

Is it possible to be able to change the data source for the control on each tab?

If so, can you please show me an example of how this could be done?

Thank you,
Larry

 

[TheAceMan1]

How are ya larrydavid . . .

Have a look at the forms [blue]RecordSource[/blue] property ... in design view, put the cursor on the property line and hit [blue]F1[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]