Before Update

K

Key Powell

Where can I find information on how to use the Before Update Command?

Key Powell
 
M

Mr. B

Access HELP

--
Regards

Jeff Boycewww.InformationFutures.net

Microsoft Office/Access MVPhttp://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentorhttp://microsoftitacademy.com/







- Show quoted text -
Click to expand...

The term is "Event" not "Command". When you look in the Help file,
look for Events. There are several "Events" that occur in a specific
order. These "Events" are slightly different for each type of
control, form or report.

As Jeff has said, look in the Access Help file, but you also may want
to just experiment with placing code in an event to test just how it
reacts. One good method to see how and when the event works is to use
a MsgBox like:

Msgbox "Hello World"

When places in an event like the After Update event of a text box, the
message "Hello World" will be presented, along with an OK button after
you have made any entry in the text box and pressed the "Tab" or
"Enter" keys on the keyboard.

After you kinda get the concept down, you can then expand this with
other code and pretty soon you will be gaining control of your
application through VBA code.

HTH

Mr. B
 
Top