add code to Navigation Buttons

  • Thread starter Thread starter nitoglycerine
  • Start date Start date
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?
 
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).
 
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
__________________________________________
 
Back
Top