philbullock1223
Registered User.
- Local time
- Today, 10:19
- Joined
- Dec 31, 2011
- Messages
- 55
To put it very simply, I have created a form with a subform. The only reason I am using a subform is because I have too many fields and I need a "scroll box" within a set of tabs. I have found no other way to do it.
This method works great except for one scenario: adding records.
I have about 15 fields that I need to display, so the 15 fields are on a subform. The form and subform both reference the same table. The form is linked to the subform on its AutoNumber.
When I add a new record, the subform doens't seem to be linking to the newly created record and I am getting errors when adding values.
I have attached an example I made. The form I am concerned with is called "SAMPLE RECORD." You will see that if you open it, it works like I want it to, but if you click the + to add a new record, if you start typing data in the subform I quickly get errors when exiting.
Any help would be greatly appreciated.
Phil
This method works great except for one scenario: adding records.
I have about 15 fields that I need to display, so the 15 fields are on a subform. The form and subform both reference the same table. The form is linked to the subform on its AutoNumber.
When I add a new record, the subform doens't seem to be linking to the newly created record and I am getting errors when adding values.
I have attached an example I made. The form I am concerned with is called "SAMPLE RECORD." You will see that if you open it, it works like I want it to, but if you click the + to add a new record, if you start typing data in the subform I quickly get errors when exiting.
Any help would be greatly appreciated.
Phil