Single event affecting multiple fields

[joseppi01]

Hello

I have downloaded an Access template from microsoft, and am trying to edit it a bit to give me exactly what I need.
(database = Desktop Time Card)

I have changed the field of 'Date Worked' to Date Time Entered, and added an extra 'Date Time Exited' field - I am trying to keep track of visitors into our complex so need to be able to sign them in and out.

I have added an event to the Entry time, dblClick will auto populate Now(). I've also added in the same dblClick of Now() to the Exit time. Unfortunately, when I dblClick the Entry it auto-populates both fields??

Private Sub Date_Time_Started_DblClick(Cancel As Integer)
Me.Date_Time_Started = Now()
End Sub
 
Private Sub Date_Time_Finished_DblClick(Cancel As Integer)
Me.Date_Time_Finished = Now()
End Sub

Any help is greatly appreciated...Thank you

[jimatqsi]

Look at the properties of the two text fields, Date_time_Started and Date_Time_Finished. Specificaly, look at the Data tab. What field name are these text boxes bound to? I'm thinking they are both bound to the same data item so when you change one you change them both.

They need to each one be bound to a different data item from the table they live in. Did you add a text box to the form without adding a new field to the table being edited?

Jim

[joseppi01]

Hi Jim

Totally fixed...of course it was something very simple! That'll teach me to not use Access for 6 months and expect to still be competent!

Thank you very much