i've read the Access 2019 Bible, watched countless utube videos yet I can not get the dlookup function to work.....grrrrrr
It is a membership app with a members table hooked 1 to many to addresses, there is no relatioship from the uszipcodes table. I want the user to type in a zip code which does a dlookup to fill in the city and state. sounds straight forward. Yes i have a u.s. zipcode table.
Can you look at my file and tell me what I need to know to make it work? accdb attached