Synchronizing Forms

[Michael Laferriere]

Hi Folks - I'd like to use a form/subform setup in my database. It works
perfect ... if there is a match between form and subform, then the subform
lists the related records. If there is no match, then it has a blank record
displayed for adding records. Plus, Access takes care of the relational
housekeeping.

However, my main form is not big enough to accommodate a subform, so I need
to open the "subform" in its own window. Using the Command button wizard, I
am able to open the "subform" to the related main form record. However, if
the main form recordsource does not have a related record in the "subform"
recordsource, this technique will not allow me to add a new record. Make
sense? Any ideas or better techniques? Thanks.

 

[Joe]

Michael,

If I understand your question correctly, what you can do is add
the linking field between the 2 forms onto the subform and set
its visible property to false.

Then set its default value propery to the linking field on the
main form.

ie. Default Value: =Forms![MainForm]![LinkingField]

HTH,

Joe