Locopete99
Registered User.
- Local time
- Today, 05:35
- Joined
- Jul 11, 2016
- Messages
- 163
Hi Guys.
I have a form and 2 fields are related
1st is a Responsible field which the user selects the user that is responsible for the task. This is a look up value from Tbl_User.
Once the user selects the responsible user the form stores the ID.
I then have an initials field. This should look up the responsible fields user in from the Tbl_Users field. I need the initials to add to the ID to make the enquiry number - ####XX
I'm using the following for the default field but its not working. Can someone advise?
I have a form and 2 fields are related
1st is a Responsible field which the user selects the user that is responsible for the task. This is a look up value from Tbl_User.
Once the user selects the responsible user the form stores the ID.
I then have an initials field. This should look up the responsible fields user in from the Tbl_Users field. I need the initials to add to the ID to make the enquiry number - ####XX
I'm using the following for the default field but its not working. Can someone advise?
Code:
=DLookUp("[Initials","Frm_User",[ID]=[responsible])