Data Entry Form Allowing User to Choose from a List of DLookUp Values (1 Viewer)

screentone

New member
Local time
Today, 10:26
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!
 

theDBguy

I’m here to help
Staff member
Local time
Today, 08:26
Joined
Oct 29, 2018
Messages
21,358
Hi. You can use a combobox on a form to display the choices and have the user select the one they want. You can then add code to the AfterUpdate event to perform any task you need for the selected item. For example, open another form to modify other details about the item selected.


Edit: Ah, what Uncle said. I was too slow...
 

Users who are viewing this thread

Top Bottom