Touch/Click add info

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to click on a button or control in a form add with each
click have it increase the value by 1 in another text box. i.e. Click on a
button labeled "Coffee" and have the value in the "Coffee Purchased" field
increased by one.
Thanks
Mike J
 
Me!NameOfTextBox = Me!NameOfTextBox + 1

If the starting value of the text box may be Null, you may need to include
the NZ function in the expression ...

Me!NameOfTextBox = NZ(Me!NameOfTextBox, 0) + 1

See 'NZ Function' in the help file for details.
 
Sorry for being dense. What kind of field or button should I use and where
should this code be placed? e.g. a text field, a bound object etc? place
code in an event property? Should this new click button have a control
source linked to the table? Thanks
Mike
 
I need a little more help. What kind of box or button should l use? Where
should this code be placed - in an event, as a macro etc???? Should this
new click button be tied to the table through the control source? Do I need
to do anything different to the text field that will be incremented by by
this click button? I currently directly enter a number into this text field.
Thanks
 
Back
Top