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

On the main form, I have the basic information on the data I am tracking.
However, one piece that could vary is how the final response was shipped:
Federal Express, U.S. Mail, Hand Delivered, or Interoffice. For these, I
have developed subform.

Unfortunately, when a record on the main form is displayed, and you don't
know up-front that it was shipped U.S. Mail and click the Federal Express
Button, the first record for Federal Express is displayed, rather that US
Mail. This record is displayed regardless as to whether it is the method of
shipment for the main form record. How do I tie the correct method of
shipment to the correct main record.

In order to click the right delivery method button (Federal Express, US
Mail....) for the displayed record, you have to know the method of shipment
upfront.

I need for the coordination to automatically take place. When the main
record is displayed, highlight the cmdButton for shipment type and 'gray out'
the other buttons..

Can you help me with the code?

"Rob Oldfield" wrote:

>
> 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