Re: display subform record in main form

yes, the main form is to display the record (in form view) of the subform
records (data*** view). you can also manually enter the in fosmation in
the mainform. If this record is not in the list of subform it will add the
record to subform.

"Allen Browne" wrote:

> hngo, I don't understand the reason you are doing this.
>
> Is the subform intended to be the way the user can find the record you want
> to display in the main form?
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "hngo" <hngo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:6F2702A5-EA94-4830-A6A7-C7EF527CB029@xxxxxxxxxxxxxxxx
> > WELL,
> >
> > I think because the information has always been presented like that
> > before
> > from other database.
> >
> >
> > "Allen Browne" wrote:
> >
> >> why?
> >>
> >> "hngo" <hngo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:66080C92-8F1B-4805-8F0B-99C59B775514@xxxxxxxxxxxxxxxx
> >> > Hi Allen,
> >> >
> >> > May i have not explain this good enough:
> >> >
> >> > try again: the subform display the information data
> >> > The main form will allow the user to add the new data.
> >> > But
> >> > also display the existing information in sub form(in data *** view)
> >> >
> >> > "Allen Browne" wrote:
> >> >
> >> >> This interface is backwards to how subforms are designed.
> >> >>
> >> >> If you are trying to use a subform to select which record you want in
> >> >> the
> >> >> subform, can I suggest you use a list box for that purpose instead of
> >> >> a
> >> >> subform.
> >> >>
> >> >> 1. Create a new, unbound form, and add a list box.
> >> >> Set the RowSource of the list box to just the columns you need to see,
> >> >> plus
> >> >> the primary key field as the bound column of the unbound list box
> >> >> (zero-width column if you wish.)
> >> >>
> >> >> 2. Add your existing main form as a subform beside the listbox.
> >> >> Set the LinkMasterFields of the subform control to the name of the
> >> >> listbox,
> >> >> and the LinkChildFields to the primary key field name of your form.
> >> >>
> >> >> As you select a record in the list box, the record is shown in the
> >> >> subform.
> >> >> No code needed.
> >> >>
> >> >> --
> >> >> Allen Browne - Microsoft MVP. Perth, Western Australia.
> >> >> Tips for Access users - http://allenbrowne.com/tips.html
> >> >> Reply to group, rather than allenbrowne at mvps dot org.
> >> >>
> >> >> "hngo" <hngo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> >> news:F54F9A68-DE64-4CA4-9DF5-66765EC97ADD@xxxxxxxxxxxxxxxx
> >> >> >I have a main form with a subforms. I need to find a way when display
> >> >> >a
> >> >> > record in the mainform while i am browsing the subform with store
> >> >> > all
> >> >> > the
> >> >> > records.
> >> >> >
> >> >> > The main form can also be used to in put new record for the subform.
> >> >> >
> >> >> > Thanks for any ideas. I looked at various copying codes but none go
> >> >> > from
> >> >> > subform to main form.
>
>
>
.