Default values based on other fields

[rickyzicky]

I have a field called [employesID]
If the employee # is "316", is it possible to set up the
[employeePhoto]field to have a defaults of:
[employeeid].jpg

Thanks in advance.

RZ

 

[PaulBricker]

Not exactly but you can accomplish the same thing using the On Current event so that the form looks at the EmployeeId and then inserts that particular .jpg file if appropriate. In the On Current event for the form you would have code that says

If Me.EmployeeID = "316" Then 'assuming ID is a text value
Me.EmployeePhoto = employeeid.jpg
Else
End If

That should get you close.

Paul

 

[rickyzicky]

Thanks;
For my needs, I don't believe that would work since I am incorporating it in asp. I would need to do it at a table level or in asp. I was trying the easy way first.
RZ

 

[PaulBricker]

What, exactly, are you doing? Are you using any forms or are you just working at the table level? Some addtional info might help spark some ideas.

Paul