Textbox data in VBA

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

Guest

Hi, I am extremely new to VBA and I am a little confused. I want to take
user input from a textbox on a form and add it to a constant number, then
store that sum in a table. How can i do this in Access 2007?

Thanks for the help. I looked for similar questions asked previously and
found none. Sorry if I missed the answer.
 
First of all you need some kind of event to execute the code.
Do you want to do it from a button click or just after the user has entered
the data?
You will also need to validate that the user has entered a number using
IsNumeric()
Is the from bound to the table where this value is to be stored?

Steve
 
I would like for the event to take place as soon as the data has been
entered. The form is bound to the table . Thanks in advance for taking the
time to help me out with this.

Rich
 
Back
Top