Hello.
I am creating a database that allows for single-click sign ins and sign outs that timestamp with an employeeID to keep track of hours.
I'm also doing this for clients of my day care.
The issue I'm having is that when I use my buttons in the forms, they work great. But when I try to use them through a Navigation form, I get the error:
"You cannot add or change a record because a related record is required in table 'table_Clients'"
I've been trying for a week to figure out how to reference the subtable within the original form, within the navigation form, but I can't seem to get it.
Here's the macro I'm using now for the sign in button:
Control Name: subform_SignIn //this is the name of the subform that is shown on the sign-in form
GoToRecord: Record: New
SetValue: Item: [subform_SignIn].[Form]![SignInType]: Expression ="In"
SetValue: Item: [subform_SignIn].[Form]![SignInTime]: Expression =now()
SetValue: Item: [subform_SignIn].[Form]![SignInDate]: Expression =now()
I feel like I have an idea what it's *supposed* to do, but I'm new to Access and I'm so stuck on this. Thanks!