How do I send data from a Form Text box to a Column in a Table?

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

Guest

So, I'm trying to take data that has been input into a TextBox in a form in
Access. And copy that information to a particular column in a table, when the
user clicks the OK button. Any suggestions?
 
So, I'm trying to take data that has been input into a TextBox in a form in
Access. And copy that information to a particular column in a table, when the
user clicks the OK button. Any suggestions?
Click to expand...

ummm...

use a simple bound form, with the form bound to the table, and the
textbox to the field, and not bother writing any code at all!?

You can do this by using an unbound form/control and putting code in
the button's Click event, opening a Recordset based on the table,
navigating to the desired record (or using the AddNew method to create
a new record), setting the field to the form's value, issuing the
Update method, etc. etc. - is that what you want to do? If so why?

John W. Vinson[MVP]
 
Back
Top