Still having problems with this:
I'm designing a database that will track triathlon training workouts and plans (to start with). I have three initial tables:
AthleteID (PK and auto)
HealthID (PK and auto)
WorkoutID (PK and auto)
Time of Day
Type of workout
I want to have a form with two tabs. The header of the form will have the Date input and tab 1 would be the health info for that day, and tab 2 would be to enter the workout(s) for that day. I have the Health and Workout tables linked by AthleteID and date and have the following code (courtesy of a forum member) to handle the date for new records:
Private Sub Form_BeforeInsert(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
[Date] = Forms![Users]![Date]
Problem is that I don't know how to have a date input on the header (i.e. where to get it from). When I open the form I get two successive date input requests and then the error The LinkMasterFields property has produced the following error: This object doesn't contain the automation object 'date'.
Any help is greatly appreciated.