Textbox data in VBA

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.
 
G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Importing csv daily files into access 2007 1
On Enter event 3
is there an "end" character at the end of a .body command in VBA? 5
data into vba 2
Update a Textbox on a Form with Field Value via VB. 6
Textbox to array to combobox 3
Data Type in Textbox 1
How can VBA learn whether a TextBox is bound? 2

Top