add code to Navigation Buttons

N

nitoglycerine

Hello,

I create a form thru the wizard that connect the text boxes on it to a
query.

Now I want program a a text box that shows the total for one of the
fields. To do so, I need to add such function to the navigation
buttons, how can I do it?
 
R

Rick Brandt

Hello,

I create a form thru the wizard that connect the text boxes on it to a
query.

Now I want program a a text box that shows the total for one of the
fields. To do so, I need to add such function to the navigation buttons,
how can I do it?
Click to expand...

No need to mess with the nav-buttons (you can't anyway). Just use the
Current event of thhe form. That fires every time you change records (as
you arrive at the new one).
 
T

Tom Wickerath

Here are some examples of Query By Form (QBF), mentioned by Rick Brandt in
his reply:

http://www.accessmvp.com/TWickerath/downloads/customdialogbox.zip
http://www.accessmvp.com/TWickerath/downloads/elements.zip
http://www.accessmvp.com/TWickerath/downloads/Chap08QBF.zip

http://www.seattleaccess.org/downloads.htm
See the download "Query By Form"
Tom Wickerath, February 12, 2008


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Top