Base: how can I pass data from subform to mainform in base?
I have a text field in the subform - during data entry the text field in the subform is filledin and saved- and when the mainform is saved the text field from the subform is to be passed to a text field in the mainform and saved .
Please help.
You can do this with a macro but it is against all logic. One of the objectives of a relational database is to avoid redundant data storage. What you are stating goes completely against this. Why not just create a flat file & store all data in one record? Not logical.
I want to pass the name field entered into the subform (the subform is linked to the Players table) instead of the user reentering their name into the subbmittedby field in the mainform (is linked to the Application table) I want to take the first name of the list of players (subform) and put it in the submittedby field of the mainform. Hopefully this can help data entry The database is still normalized.
What are your thoughts?
From what I read, the main form is the “Application” table and the sub form is the “Players” table. Correct? Isn’t “Players” table linked to “Application” table? Still unclear as to why you need this name in both tables.
Regardless of the situation, if you want information passed from one form (or sub form) to another and have the receiving record to be updated, you will need a macro written specifically for your form and record layout.
@jocko1, Please attach your database to your question above (use the little paper-clip icon to do it) so we can see exactly what you have. (Be sure no private information is in it first.) Thanks