Save referenced value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with many subforms. Items are selected on subforms and shown on
main form. How can I save what has been selected? Maybe I should ask can
the default value of a bound control be a referenced control on subform?
Thanks
 
I have a form with many subforms. Items are selected on subforms and shown on
main form. How can I save what has been selected? Maybe I should ask can
the default value of a bound control be a referenced control on subform?
Thanks
Click to expand...

This seems a very unusual approach! What is your table structure? What
information are you copying (?) from the subform to the mainform's
table? I worry that you may be storing data redudantly!

To directly answer your question - no it cannot; in fact typically a
mainform will have *one* record linked to *many* records on each
Subform, so "the record" on the subform is not usually meaningful
(which one?). I wonder if you should perhaps be using Listboxes or
Combo Boxes instead of subforms; these can be bound to a table value.

John W. Vinson[MVP]
 
After reading your reply I reworked my structure to use a combo box. Thanks
for getting me back on the right track.
 
Back
Top