Tab control question

[hunterfan48]

Why can I not put unrelated fields from unrelated tables on different pages of the tab control? Why do they all have to be related to the 1st field from the 1st table I add to the tab?

Thanks!
Brady

 

[stopher]

The reason is that a form can only be bound to one datasource (table). So any bound fields must also come from that datasource. The tab control is only a way of splitting fields visually. As far as Access is concerned, they are still on the same form.

However, you can create a subform (with a different datasource) and put the subform in your tab control. So each tab can have a different subform and hence a different datasource.

hth
Chris

 

[hunterfan48]

The reason is that a form can only be bound to one datasource (table). So any bound fields must also come from that datasource. The tab control is only a way of splitting fields visually. As far as Access is concerned, they are still on the same form.

However, you can create a subform (with a different datasource) and put the subform in your tab control. So each tab can have a different subform and hence a different datasource.

hth
Chris

Wouldn't that have to be related to the table that the fields are referencing on the 1st tab? Could the subform be completely different and not related to the 1st fields in any way?

thanks,

 

[stopher]

Wouldn't that have to be related to the table that the fields are referencing on the 1st tab? Could the subform be completely different and not related to the 1st fields in any way?

thanks,

When you add a subform to a main for, then typically you will set the master/child attributes to "relate" the subform with the respective record from the main form. But if you don't set the master/child attributes then the subform is just independent.

For instance, you could create a blank main form then add three subforms. Each subform would be independent. This can be quite a useful way to have three tables on the go, so to speak. You don't even need to have the tab control. But the tab control just helps you utilise screen space better.

hth
Chris

 

[hunterfan48]

Perfect...thanks for explaining that Chris.

Maybe I should explain further what I'm trying to do with this form...

I have a table for my customers, a table for my sports cards that I have, and a table for the transactions that occur with these sportscards.

So, I need to create a form (to save time and make this process more efficient) to help me enter sports card transactions involving my customers. I would like to be able to do something along these lines.

1)picking a customer from a list for this new transaction (or being able to open up a new form to enter a new customer on the go)

2) Enter info about the transaction, i.e. date, description, price, etc.

3) Search through my sports card inventory table to find the correct cards to tie into the transaction

That's about it, lol if that sounds simple I'm not sure but that's what I'd like to do.

As of now, I have to go into each form seperately and it takes forever!

Thanks for the help guys!