Tabbed form

[endri81]

I have a tabbed form which has to be connected with more than one table or source control.How can I make possible this?

 

[vbaInet]

Create a query to combine records from the tables concerned and use that query as the record source of your form.

 

[boblarson]

I'm going to disagree with vbaInet on this and say you need to use a subform on each tab.

 

[vbaInet]

Just answering as it was asked Bob - one form, multiple tables

 

[boblarson]

Just answering as it was asked Bob - one form, multiple tables

But just answering due to the question can be extremely misleading, especially if you start adding tables to a query it can easily become non-updateable. So, yes I understand where you were coming from. But I'm coming from a spot where I see too many people trying to do too much with a single form.

 

[vbaInet]

Hehe!! I know what you mean What the OP will then realise is that his original idea of a single form approach isn't working and come back on here for more advice. A good way to learn sometimes