Looking for Opinions from Access Experts

  • Thread starter Thread starter AJ
  • Start date Start date
A

AJ

Hello. I am new to access and am looking for some opinions. I have a form
with two input fields (storeA, storeB). The user needs to enter StoreA and
the address, city, etc information will pop-up (visible label), user then
enters StoreB , address, city, pop-up for StoreB. Also a mileage will be
dispalyed for the distance between both stores. Once all that is visbile the
user will decide if they want to run the application.
What I am looking for is when to have all these things happen. Currently I
have a run button. Should I perform a validation to make sure th estore
exists and then populate the address information on loss of focus? When they
click run? What happens if they tab away from the field without entering
anything?
Again I am new to access and looking for the best way and most user freindly
way to set up the form. (Also to eliminate errors.)
Any and All opinions appreciated. THANK YOU IN ADVANCE.
 
On Sun, 23 Dec 2007 20:00:00 -0800, AJ <[email protected]>
wrote:

You populate the store address in the AfterUpdate event of the Store
fields. You validate for accuracy of store name entry in the
BeforeUpdate event, and set Cancel to True if not valid.
Or use a dropdown rather than a text field.

-Tom.
 
Back
Top