Updating a table with a DLookUp text box

[adrianf44]

Good morning,

I have a Contacts table with my users and a Location table with the Location, Address, City and Zip of the users. Right now on my form I'm using a dropdown to select their location and using a DLookUp textbox to fill in their address based on the location I choose. I added columns to my Contacts table for Address, City and Zip and would like to fill in those fields based on which location I choose but I haven't been able to figure it out.



My Contacts table is linked to SharePoint and I would like to be able to share their address with other users

[isladogs]

That's not the way to do it.
Make sure your ContactsID PK field is a foreign key in your Location table.
Link both tables using this field and use that as your form record source.

Now you will have the correct location details for each contact on the form.

I don't use SharePoint so can't advise on that part.