Split up one record into multiple sub-forms using navigation option

[mhe5026]

I have one single form with multiple sub-forms that are used to split up one record. The record had many fields, and I thought it would be easier for the user. I wanted to set each of the sub-forms to the properties "data entry" option so it would only store records in the table and not in the forms to speed up the forms. However, every time I click through the tabs it starts a new record for each of the subforms and I may have 10 records in my table as I intended to be one. I want all the sub-forms and the fields in them to be treated as one record, with one "data entry" property. Is this possible?

[pbaldy]

I would try a tab control instead of subforms.

[mhe5026]

Thats what I have. Multiple tabs that open up various subforms. Im just having trouble keeping them all on the same record.

[amrut]

Subforms are used to display a typical One-To-Many relationships and not for splitting a single record. The subform, when linked correcly, display the details of each master record. For ex. a subform can show a list of order details(list of items ordered,quantity etc) for a particular order. See here for more on it http://www.techonthenet.com/access/subforms/link.php

I wanted to set each of the sub-forms to the properties "data entry" option so it would only store records in the table and not in the forms to speed up the forms

Records are always stored in table and forms serve as medium to add/edit data in a "presentable" manner to the user. Can's understand what you mean by "speed up the forms" ??

[mhe5026]

Or at least how would I make an "Add new Record" Command Button that worked across all subforms at once. I think that is what would solve this.

[pbaldy]

Why do you have subforms for a single record? Just have textboxes organized on tabs.

[mhe5026]

I broke up the some 60 fields I have into categories and made them separate forms. I used the navigation control, which opens up a sub-form that views other forms.

[mhe5026]

sub-form, a form within a form.

[pbaldy]

I'm well aware of what a subform is; I use them frequently. This just isn't the proper situation for them. If the data is all in one table, it can (and I think should) be represented on one form (or subform), with a tab control to organize the fields logically.

[mhe5026]

That would make my screen about a mile long, and navigating difficult for the user (If all fields were inserted into one form). This is for building maintenance, it's not a four or five question form. Any suggestions on breaking up the questions? My idea was too separate the questions into categories, making a separate form for each category (so, if for later, i wanted to add more questions to the forms in certain categories it would be easier) and then making one MAIN FORM that would use the navigation control (which pretty much previews other forms or "sub-forms" by use of tabs) to go to the selected categories. I just want all sub forms on the main forms to correspond to the same record. I know i can do that if I can make an add new record button that works accross all subforms at one time. Just don't know the code. This is an undoubtedly an appropriate way to separate content. There's what my form looks like so far. If you can't answer the question, please don't respond.

[eki einstein]

i think you canot doit by navigiation form, but i understand what you mean about give the user more user friendly GUI, i suggest flow form, yes it split the form to separate part, this some example DB whit flowing formflowingform sample1.accdb

[ssanfu]

I broke up the some 60 fields

Doesn't sound like a normalized table, but I don't know the requirements.

Using a TAB control instead of subforms has been suggested twice. I am in total agreement with Paul.
If you had a normalized structure, then probably I would use subforms.
If you do more than one inspection on one building, I would look into normalizing the table structure.

That would make my screen about a mile long, and navigating difficult for the user (If all fields were inserted into one form).

Maybe not. Again, I don't know how many fields (controls) you have in the current subforms, but a TAB page will hold lots of controls if they are sized correctly.

make an add new record button that works accross all subforms at one time. Just don't know the code

In the click event, add a line for each subform to append a new record (insert into...)
BUT, if each subform is tied to the same record and you have 8 subforms, you would insert 8 new records.

Soooooo, one record with 60 fields = use TAB control.

If you can't answer the question, please don't respond.

Good luck with your project. With statements like that, I don't think you will get much help. You asked, you received answers. Maybe not the answers you wanted, but.....


BTW, in your form, in the last control label LOCATION is misspelled

I'm gone........

[June7]

Subforms on a tab control are not appropriate for this situation. Distributing fields over multiple pages of tab control is simplest and easiest approach. Why would screen be 'a mile long' with use of tab control? Idea of tab control is to compact the form. Why would navigating a tab control be more difficult than navigating a navigation form?

Code to 'create new record on all subforms' makes no sense because there IS ONLY ONE RECORD.

The record is created with first data entry to any one of the subforms. My understanding of navigation control/form is that the subforms are not all active at the same time. Save the record then other subforms open filtered to the just saved record.