Can I use the value of a field as predeterminate value of another.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am making a table to know who is working in each surgery in a heath center.
For each day, I have a field "owner" (of the surgery) and another "working"
(the one that really works that day there). But the majority of the days, the
"owner" is who works in his surgery, so I want to establish the value of
"owner" as predeterminate value of "working" . Is it possible?
Thank you
 
Open the form in design view
Right click the form (outside the detail area)
Open propertiy box
Select the Event column
Select the OnLoad event
Select build option (...)
Select code
Use this

Private Sub Form_Load()
Me.working = [Owner]
End Sub


Change the control names to what they really are

Good luck
 
Back
Top