Use main form and subform to create single record

[Isaac Martin]

Hello,

I hope someone out there can help, or can tell me if what I want is
impossible. I have a form and 2 subforms that use the same table as
the record source. What I want to do is have the data entered into
these forms combined into a single record on the source table. The way
it is currently linked (with a standard master/child field indicated)
is resulting in multiple records.

This is for an audit evaluation, used for call center employees. The
reason for the subforms is that depending on the call type (sale or
non-sale) there are different audit criteria. I have my main form set
so it only displays the subform associated with the call type selected
from a drop down menu. There wasn't enough space to display both sets
of questions on one form, so subforms seemed like the best solution.
However, as the records will primarily be used for a variety of
reporting needs it would be helpful to have each audit stored as a
single record within one table.

Any ideas on how to create a single record on a single table from
multiple forms? Any suggestions are appreciated! Thank you!

 

[Rick Brandt]

Hello,

I hope someone out there can help, or can tell me if what I want is
impossible. I have a form and 2 subforms that use the same table as
the record source. What I want to do is have the data entered into
these forms combined into a single record on the source table. The way
it is currently linked (with a standard master/child field indicated)
is resulting in multiple records.

This is for an audit evaluation, used for call center employees. The
reason for the subforms is that depending on the call type (sale or
non-sale) there are different audit criteria. I have my main form set
so it only displays the subform associated with the call type selected
from a drop down menu. There wasn't enough space to display both sets
of questions on one form, so subforms seemed like the best solution.
However, as the records will primarily be used for a variety of
reporting needs it would be helpful to have each audit stored as a
single record within one table.

Any ideas on how to create a single record on a single table from
multiple forms? Any suggestions are appreciated! Thank you!

Use a TabControl to lay out the various groups of controls but don't use
subforms.

 

[Isaac Martin]

Use a TabControl to lay out the various groups of controls but don't use
subforms.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com- Hide quoted text -

- Show quoted text -

Thanks for the suggestion Rick, that may be the easier option. Just to
ease my curiousity, do you know if it is possible to have a form and
subform set up to enter data for a single record? Thanks again for the
help!

 

[Rick Brandt]

Thanks for the suggestion Rick, that may be the easier option. Just to
ease my curiousity, do you know if it is possible to have a form and
subform set up to enter data for a single record? Thanks again for the
help!

Possible? Yes. But as far as Access is concerned that is the same as two
different users editing the same record at one time and you will get the
same locking conflict errors unless you go to a lot of trouble to avoid
them.