Re: Synchronizing the Main form and six (6) subforms?


What do you mean by 'synchronise'? The usual relationship that exists
between records on a main form, and records on a subform is just that a one
to many relationship applies between the two (controlled by the master and
child fields properties of the subform control). If you data is in that
form, then it would just be a case of each command button setting the source
object for the subform control, and also resetting the master and child
fields (me.SubformControlName.linkchildfields and
me.subformcontrolname.linkmasterfields). It might be that you don't always
need to reset both - if the parent field for all six subforms was an ID
field then you wouldn't need to touch it.

Does that make any sense to you?


"phmckeever" <phmckeever@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:499D9E3F-739B-4721-93AD-B4A463092BCE@xxxxxxxxxxxxxxxx
> Microsoft Access 2003
>
> I have developed a Main Tracking form in Access. I have six cmdButtons on
> the Main form that 'on-click' opens difference subform. How do I
> synchronizing the data in the Main form with the data in the subform. Or
can
> this synchronization of a main form and six subforms be done? As you may
> have noted, I am extremely new at this.
>
> Any help is greatly appreciated.
>
> patricia


.

Loading