INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

populating form and subforms input into same table

populating form and subforms input into same table

(OP)
hi
I am new to ms access.I have created a form in designer and added a sub form to it with source object to a table. I want to add multiple records from sub form to table. I have two fields name date and entry no # in which I will input same values in multiple rows. I would like to know if I add two text boxes in the main form and bind to columns entry no# and date how to assign these text box input to all rows entered through subform?

Thanks

RE: populating form and subforms input into same table

In the subform control (the container holding the subform) you will see the properties
linkMaterFields:
linkchildFields:

If there are two fields that link the main table to the sub table then you list the names of both fields seperated by a semicolon
[entry no#];[Date]

BTW both of your fields names are horrible. Never put spaces in a field name, never use special characters, and never use reserved words such as a name of a function (Date is a vba function to return the date). You do all three. Better is
Entry_Number
Entry_Date

If you establish the link you do not have to do anything else. It will populate the child fields, and or filter on the child fields. If the Master fields are not field names but just unbound controls on the main form you can do that as well. Example
linkMaterFields:txtBxEntry_Number;txtBxEntry_Date
linkchildFields:[entry no#];[Date]

I have to use [] for any "bad" field names. Not required otherwise.



RE: populating form and subforms input into same table

(OP)
Thank you so much for your reply. I have not tried yet but I would like to know would the text box input populate main tables field with equal row of sub form records?

RE: populating form and subforms input into same table

Quote:

I would like to know would the text box input populate main tables field with equal row of sub form records?
I do not know what you are asking. If you set up a normal Main Form - Sub Form, every record added to the subform will be given a foreign key value that relates it to the parent record in the main form.

RE: populating form and subforms input into same table

(OP)
Thanks

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close