Tab control preferences?

[wader]

Looking to create a new data entry screen in my 2007 access database. Thinking about using tab control because I think it looks clean to group on each tab. Trying to decide if I should use a query for the record source and populate embeded forms for each tab or if I should just add the table field I want to each tab...

Any thoughts/conserns? Thanks for any feedback

 

[Old Man Devin]

If you plan to have lots of tabs then that query will get complex and messy quickly. Unless the tabs are going to be all be displaying information from the same table, I would recommend setting up forms for all the different tab categories and then embedding them as subforms in the individual tabs.

This is how I've always done things, and the only downside I know of is that when you have lots of subforms that all need to load when you open the main form, it can make the form slow to open, especially if the subforms are doing calculations and the like. But even with 10 or subforms, it's only going to take a few seconds on a fast computer.

 

[gemma-the-husky]

in general, though, base all forms on queries, rather than tables directly, if you need to sort or filter the items, it is easier with queries, than tables.

 

[wader]

Embeded subforms seem to be doing very well. I ran into a limit of 7 tabbed subforms but I think I can make that work. Not sure if there is a way around that other than creating and linking to seperate forms. Thank you for the feedback.