I have a form (QUOTE_MASTER) that is derived from a table (also QUOTE_MASTER). I have a field (QTL_ASSGN_QS_DATE) that I want to auto-populate with Date/Time when I populate a text field (QTL_QS_EMP_NAME). The text field (QTL_QS_EMP_NAME) is a drop-down box - the list is based on a table (QS_EMPS). I have tried the following:
- From the form (QUOTE_MASTER), I have entered the following formula:
- In the field box for (QTL_QS_EMP_NAME), for the event, "On Change", =IIF (Not IsNull([QUOTE_MASTER]![QS_EMP_NAME]), ([QUOTE_MASTER]![QTL_ASSGN_QS_DATE]=Now()), ([QUOTE_MASTER]![QTL_ASSGN_QS_DATE] is Null))
- In the field box for (QTL_ASSGN_QS_DATE), as Default, =IIF([QUOTE_MASTER]![QS_EMP_NAME]<>Null, [QUOTE_MASTER]![QTL_ASSGN_QS_DATE]=Now(), [QUOTE_MASTER]![QTL_ASSGN_QS_DATE=Null)
- I have tried the same directly in the table (QUOTE_MASTER).
And others that I can't remember - am I having this problem because the field (QS_EMP_NAME) is a drop-down box based on a table? If not, can someone please help me with the syntax for this function?
Thanks!
Vanessa