Time Comparison

[Larry819]

We are using a form for data entry of results which can be used by multiple people. We have no security set up as of yet on the DB. We have a field called technician in on of our forms where the person doing the entry type their name. We want to build an expression in the default value to work as follows: if the current time is between 7am and 3pm, then John Doe, then Jane Doe. This is a simplified version, but I am having trouble getting the right syntax. I could also make the field a list box and have the individual just choose their name, but would prefer the method above. Thanks for the help

[thhui]

Create a Table Technician to have field
TPerson (if you haven't yet)
to store all technician names:
John Doe
Jane Doe

Create a comboBox cboT on the input form to store the technician name.

Set its datasource as

SELECT Technician.TPerson FROM Technician ORDER BY Technician.TPerson;

Set its default as a function
=CurrTech()

Function CurrTech()
hr = Hour(Now())
 
If hr >= 7 And hr < 15 Then
CurrTech = "John Doe"
Else
CurrTech = "Jane Doe"
End If
End Function