Originally Posted by
Bob Fitz
...I wouldn't necessarily say this is the best way, but instead of having Sub forms on each tab, try putting just the text boxes (questions) on the tabs directly...
Anytime there are more than 25-30 Fields, in a single RecordSource, we always wonder whether the database is properly normalized, but assuming that it is, Bob's suggestion is exactly how I would approach this.
Keep in mind that when placing the Controls directly on the Pages of a Tabbed Control, they are referred to as if the Tabbed Control didn't exist. In other words, if you had ControlA on a Form, you could do something like this:
Me.ControlA = Date()
If you then added a Tabbed Control, and moved ControlA onto a Page on the Tabbed Control, you would still use:
Me.ControlA = Date()
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007