Hi,
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:

tblUsers
AthleteID (PK and auto)
First Name
Last Name
Address
Email
Comment

tblHealth
HealthID (PK and auto)
AthleteID (FK)
Date
HR resting
Sleep time
Illness/Injury
Weight
Comment

tblWorkouts
WorkoutID (PK and auto)
AthleteID (FK)
Date
Time of Day
Sport
Type of workout
Route
Equipment
Duration
Distance
Speed (calc)
Pace (calc)
HR average
Comment

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]

Exit Sub

Err_Command59_Click:
MsgBox Err.Description
Resume Exit_Command59_Click

End Sub

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.
Peace