Question Tabed Control 2007

[TurboDieselOne]

Hi I need help on this one
One form

Fields - Name etc
Tab-Control
Pages
Business_address
Billing Address
Delivery Address

Other in - Not on Tab-Control

I have a table for Suppliers name etc
I have a table for Addresses
I have a Table for Address type

I need to put each address for the Supplier on the tabed- Control

Is this possible without having 3 sub Forms.

Thanks

 

[RuralGuy]

Are you saying you would like each address on a different tab?

 

[TurboDieselOne]

Yes Each type on each tab.

There are only 4 Types,


Billing
Business
Delivery
Registered

 

[RuralGuy]

Regardless of the tab, each control on the entire tab control is unique. Since you have 4 unique addresses in your table, placing each one on a different tab of the tab control should not be a problem.

 

[TurboDieselOne]

Does a seperate Query need to be used for each Tab-Page.

 

[RuralGuy]

Nope! Each field is available in the RecordSource of the Form so just add them to the appropriate tab page.

 

[TurboDieselOne]

It does not work
When I add a Billing address on the billing tab I see the same address on all the Tabs

 

[RuralGuy]

You need to Cut the control, then select the page and Paste the control.

 

[TurboDieselOne]

I have uploaded 2 screen shots. also the database. I can do the vba and all that stuff but this Multiple addresses and tabs like in Filemaker would look good and can I can put this across all the Other DB's I am creating like Invoicing and Clients and other stuff. I can use Filemaker but going forward I dont want my fledgling business spending all this money on the server side and not getting a due return so with access and splitting the databases between several it should take a while to get to the 2 gig limit.

I have installed MySQL as well