Populating subform fields from main form field
I'm building a multi-page form with subforms for a number of tables. The form is to collect very detailed information about patients, and the patientID is included in several tables.
Can the patient ID input from the main form(master table) populate a hidden field with the same patient ID in subsequent subforms?
Thanks for any assistance.
Solution
As Parfait stated the answer is yes... (at least if I understand your question correctly) You can bind these fields together using the subforms Link Master/ Child Fields Properties as circled in red
But Note: If you are using a Navigation Form this same Parent/ Child linking does not exist as these sub forms are filtered. If that is the case you will have to handle this differently probably using vba.
- Populating subform fields from main form field
- Separate column value by space and dash
- Accent-insensitive query in MS Access 2013
- 1 Access Query to Multiple Excel Files Based on Field Value
- Ucase in Access report page header
- Auto scroll to bottom with a textbox
- Trying to use VBA in Access to force string to be a specific Length
- MS Access ADODB.Recordset Cannot Add adLongVarWChar field. Error 3001 Arguments are of Wrong Type
- How can I test and handle a #Func! error from within a query?
- Error on a recordset, but same SQL works elsewhere
- How to extract the schema of an Access (.mdb) database?
- Manipulating an Access database from Java without ODBC
- How to overlap microsoft access - report detail section layout to the previous one to avoid extra rows?
- What can trigger MS Access autoexec vba macro?
- Import recordset from Access to VBA ListBox
- Check if access table exists
- MS Access: There isn't enough memory to perform this operation (Reports)
- How to pass an array to a function in VBA?
- Getting "Too many parameters for command", when calling WinSCP command-line from VBA
- MS-ACCESS Difference between TempVars and TempVar
- Create a MS Access Pivot Query that returns rows even if there are null values
- Microsoft Access SQL is clipping a string when using INSERT to add a record
- Exporting a query result into a text file using vba-MS Access
- VBA referencing external module in .accdb database "tantrum"
- Is there a shorter way of appending information to an existing string?
- How can I automatically update the data in a record when I create a new record in a different table?
- ODBC driver for MS Access seems missing (Windows 64 bit)
- Access is multiplying my query count by 38.... why?
- VBA "does not equal" code not stepping through IF statement as expected
- Issues with Uploading Files to Azure Blob Using WinINet API in VBA (Error 12031)