Auto populate in Access

  • Thread starter Thread starter matrix7410
  • Start date Start date
M

matrix7410

Hello, I'm trying to create a form in access for data entry purpose.
The form is basically informations about providers, their different
ID's, addresses, specialtiy, and bunch of Date fields. There are two
features that I would love to add to this form 1) when the user enter
the name of the provider, I would love to know if that provider name
already been entered and if it was, I would love to have all the field
in the form to be populated so that the user could than pick and
choose which field they would need to change or keep. And the 2nd
option that I would love to add to it would be the City and state be
populated when a zip code is entered in the form and I have a table
that stores all US Zip codes with the state and City. Now, I'm not
really good at writing SQL codes, so If you could give me detail
informations so that I could follow the instruction line by line.
thanks!
 
I've actually figured out how to populate the State and the City based
on the Zip Code using DLookup function. I still need your help on
figuring out the other part. thanks!
 
Back
Top