G
Guest
Hello.
I have a table «Customers» linked to a table «Zip Codes». The idea is that
when I enter a zip code in the Customers form, it gives me the respective
city from de «Zip Codes» table.
When I add a new record to the Customers table, and if I close the form
before entering a zip code it gives me an error saying something like «It was
not possible to find a match zip code from the «Zip Code» table» and «The
form cannot be saved this time». I know why this happens: the «Zip Code»
table doesn't have a blank zip code, but my question is:
What is the best way to avoid this error? Or to replace this Access message
to another one more user friendly?
I know that a possible answer to this, is to predefine a valid zip code in
the Customer form field, but is this the only way?
Someone can help me, please?
Thank you in advance.
Best regards.
I have a table «Customers» linked to a table «Zip Codes». The idea is that
when I enter a zip code in the Customers form, it gives me the respective
city from de «Zip Codes» table.
When I add a new record to the Customers table, and if I close the form
before entering a zip code it gives me an error saying something like «It was
not possible to find a match zip code from the «Zip Code» table» and «The
form cannot be saved this time». I know why this happens: the «Zip Code»
table doesn't have a blank zip code, but my question is:
What is the best way to avoid this error? Or to replace this Access message
to another one more user friendly?
I know that a possible answer to this, is to predefine a valid zip code in
the Customer form field, but is this the only way?
Someone can help me, please?
Thank you in advance.
Best regards.