G
Guest
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.
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.