Subform Issue

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
 

Attachments

I currently am utlizing tabs in my form. I guess I would say that I need even more "real-estate" than normal!

Phil
 
Can you repost the database - I can't seem open it?
 
I truly think this is a quick quick fix. I think the OnUpdate property or the OnCurrent property needs to refresh the subform or something like that.

I essentially need the subform to act as if the fields were on the form.....

Phil
 
I tried to (and did) recreate your issue, but could not fix it. Instead I changed the approach to a way I know that works. Hope this is still appropriate for you.
 

Attachments

This is a very inventive alternative, and I truly appreciate it, however I will not be able to utilize this method. I have about 100 forms, so the effort level is complicated.

Does anyone here understand the OnUpdate or the OnEnter properties for subforms/forms. I have played around with putting refresh and/or requery code within them and am getting better results but still no great solutions.

Thanks again DanSc0tt for your contribution.

Phil
 

Users who are viewing this thread

Back
Top Bottom