Multiple page form using tab feature

[Linda354]

I'm experimenting now with getting a multiple page form set up as subforms, accessed by tabs. I have a main form, which is basically just being used as the header at this point, with fourteen pages of tabs under it where the fields to be input are. In testing it out, I get an error message when I click past the first field, the auto-numbered ID field: "You can't assign a value to this object: This object may be a control on a read-only form, the object may be on a form that is open in Design View, the value may be too large for this field."

I can't make heads or tails of this.

Perhaps I should explain, this is a very long form, so I have created about a half dozen tables to take in all the data. These subforms are accessing those tables (though generally only one table is used on each form.) I've set up a relationship linking the first table to all the rest on each tables "ID" field. One thing I'm not sure of is, should the ID field in all these tables be autonumbered?

 

[WildHare]

You will probably be better served to look at your data design Your problem is due to the key in the one table not being present yet in all your other tables, and you DEFINITELY do not want to make them autonumber keys.

Take a better look at your design, and make sure you've normalized things. Are these all 1 to 1 relationships?

Any form with 14 tabs worth of subforms just raises a red flag with me... 78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[Linda354]

I figured out what the problem was. I needed to have the ID field in the body of the main page. I'd had it in the header before. This is a very long intake form. There are 8 pages typewritten hard copy. In order to avoid a lot of scrolling, and to keep the row of tabs from disappearing from view on some pages I found a consistant 8 x 4 dimension to work best.