Tab control

S

SMERTZ

I want to put a tab control on a form. When a tab is clicked I want to run a
query and display the results in a table like layout. How do I change the
data source associated with the control?

There also does not seem to be a back color property for the tab control. Is
it possible to set one?

Thanks
 
V

Van T. Dinh

It sounds like you want to put a Subform in DatasheetView on the tab page.
The query you referred to can be use as the RecordSource of the Subform.

For tab colours, see Stephen Lebans' Web site:

http://www.lebans.com/tabcolors.htm

HTH
Van T. Dinh
MVP (Access)
 
S

SMERTZ

That's Great but I don't see where on the tab control to set the data
source.

Using Access 2003
 
V

Van T. Dinh

You need to add a Subform on the Tab Page and set the RecordSource of the
Subform.

Please re-read my original reply.

HTH
Van T. Dinh
MVP (Access)
 
Top