screentone
New member
- Local time
- Today, 16:30
- Joined
- May 21, 2019
- Messages
- 3
Hello, I am very new to using Access and I have been struggling with this issue.
Currently, I am trying to create an editable version of a record form that displays the Organization name for a given Contact (using a linked OrgID number) using a field with DLookUp:
'=DLookUp("Organization","OrgList","OrgID = 0" & [Forms]![ContactEditF]![OrgID])'
Is there any way for me to create a data entry form that allows the user to choose from a list of Organization names rather than entering the OrgID number? Right now I can edit every field besides the fields utilizing DLookUp.
Thanks for any help!
Currently, I am trying to create an editable version of a record form that displays the Organization name for a given Contact (using a linked OrgID number) using a field with DLookUp:
'=DLookUp("Organization","OrgList","OrgID = 0" & [Forms]![ContactEditF]![OrgID])'
Is there any way for me to create a data entry form that allows the user to choose from a list of Organization names rather than entering the OrgID number? Right now I can edit every field besides the fields utilizing DLookUp.
Thanks for any help!