microsoft.public.access.forms

Cam.

Place a textbox on the main form and name it the same name as the Part#
textboxes in the two subforms. For my example I will say TxtPartNumber.

So the mainform and each subform have a textbox named TxtPartNumber.

In Subform2 set the LinkMasterFields and LinkChildFields properites to
TxtPartNumber.

In the current event of Subform1 place this code:

Parent.[TxtPartNumber] = [TxtPartNumber]

This will synchoronize the Subform2 with Subform1.

God Bless,

Mark A. Sam



"Cam" wrote in message
news:3231E924-5428-4F35-BCEF-DBCAB4F40887@microsoft.com...
>I am designing a data entry form with two subforms within, but ran into
>some
> problem I cannot put a subform within a subform in a main form.
> What I would like to achieve are the followings:
> 1) main form - when user open, it will have an unbound field for them to
> select their IDnumber from the drop down list.
> 2) Once user input their IDNumber, enable the subform inside the main form
> for data entry. The field name "IDnumber" is automatically bounded to the
> drop down field. So user just input the Date, Part#, Oper, Time, Comments
> fields. Ps. if they did 2 part#, user can input multiple record at a time.
> 3) How can I put a 2nd subform in the main form where, when user input the
> Part# in the subform of the main form, the 2nd subform will tie to the
> Part#
> with other information related to the Part# they input (like a lookup
> form)?
>
> My other thought is to create a main form with just the IDnumber field,
> once
> the field is entered, it opens a separate data entry form, then the lookup
> subform can then be put inside this data entry form. I don't know the code
> or
> VBA or macro to do this.
>
> Also, is it possible to make the form continuous view, when there are
> subform that link to it? Thanks for any help.