Question regarding Input Forms. Can a "Parent-Form & "Sub-Form" relate to the same table? During data entry I want the "Employee" to remain unchanged, The "Date" would remain constant for a group of data entries (typ. 4-10 entries) then be changed. The other entry items would be on the "Sub-Form". I appreciate your input.
Reply from Richard Rost:
Yes, you should be able to do it. If you have a table with SELF-JOINS then you could have the parent form be "parents" and the child form "children" and both forms are bound to the PeopleT table. You would just need to specify the right join field for the subform, which would be the ParentID field. If all you want to do is set a default value for several records, you might not need to use a subform. You can probably just get away with a continuous form and a field in the form header or footer. See THIS TUTORIAL for details.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 2.
