Looking for Opinions from Access Experts

[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.

 

[Tom van Stiphout]

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.