Change record source of subform when click tab

S

Steve

Hi All,
I would like to be able to change the record source of a subform when I
click on a tab thats on a main form but I keep getting a error message.
main form is called "CardFrm"
Tab Control is called "AllTabs"
Page is called "CustomersPage"
I want the recordsource to be a query called "CardCustomerQry"

when I click on the tab I want the record source of the subform to change to
a difrent query is this posible?
Steve
From a land down under
 
B

boblarson

You have to use the On Change property of the tab control. The click event
is essentially useless.
--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subform record source tabbed page 2
Show record source in a text box 6
go to specific record based on choice in subform 2
Subform displaying incorrect record 2
Find a record based on field on other form using primary key 15
Open form to proper record 6
Combo Box Requery 1
First record on sub form 2

Top