Subform Field

[pimmc]

Hi

I'm working on a form with a subform. The (required) fields are suposed to be filled in a certain order and the fields in the subform are somewhere in the middle. The problem is that Access is making me fill all the fields in the main form first. Is it possibble to solve this issue without resorting to code?

Thanks,

Paula

 

[boblarson]

Main forms and subforms are not able to partially fill and then fill the rest unless you set the required to NO for the fields in the table. The reason is that when you move off of the main form the form saves the data and vice-versa when you move off of the sub form your subform saves the data.

If you have to fill in certain data on the subform in the middle, I wonder about the design of your database as that should NOT be a requirement.

 

[pimmc]

The subform was created in order to capture (and save on a table) more than one topic for a certain subject on a list (multiselection)... I'm using access 2003, by the way.

 

[boblarson]

Yes that would be okay, but unfortunately you cannot have fields set to required in the main table and then move to the subform without filling them in. Can you upload a screenshot of what you currently have your form looking like? I don't know if we can make suggestions on how to handle this problem but we might.

 

[pimmc]

Ok, I've uploaded a screenshot of the form (and translated all the relevant fields). The field "Topic(s)" is the one on the subform.

The idea is to use this form as a means of registering the quality of the answers given to emails which are sent to a (small) Contact Center.

Most of the evaluation parameters report to the e-mail as a whole, so it wouldn't make sense to include them on the subform; the ones that may relate to a certain topic (when more that one is present on the same e-mail), like the last one - "Question solving" - are evaluated on a partial or full compliance scale.