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!
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!