This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
The main form is for a log in event that is based on a two table query. Either a name is selected from a combo box or a bar code is entered. The name and time of entry are displayed on the subform. I need to be able to save that data to the table that the subform is based on but nothing I've tried works. What am I missing?
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I've heard that saving a calculated field to a table is redundant and can cause problems down the road. Perhaps displaying the calculated field in a report would provide the data you would like.
Link fields are correct. When barcode is entered or name selected the correct data appears on the sub form, but all my efforts to have that data saved to the table that the subform is based on fails. I've tried just to access the sub form using
Forms![ProjectCheckIn]![CheckIn_sub].Form![Volunteer_Id]
Volunteer_Id is the child link on the sub form.
Everything on the form is working fine; just this problem of not being able to save the data.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
The subform record source is a table to log check in date and time. The Volunteer_Id in this table which is a combo box that gets data from one of the tables that the main form is based on. The control source is a query based on two tables. The main form and sub form are linked by the Id and Volunteer_Id fields.
When I try to access the subform I get a message say it can't find that field.
Sounds like you have either the Parent or Child link set incorrectly. Select the Subform CONTROL (not the open the subform itself) in Design mode and check the Data tab to make sure the link fields are set correctly.
The subform record source is a table to log check in date and time. The Volunteer_Id in this table which is a combo box that gets data from one of the tables that the main form is based on. The control source is a query based on two tables. The main form and sub form are linked by the Id and Volunteer_Id fields.
When I try to access the subform I get a message say it can't find that field.
What is the recordsource of the subform and the Controlsource of the controls?