Add data from user input to table or query.

  • Thread starter Thread starter sad
  • Start date Start date
S

sad

Hi, I have a simple question. I have a form and I want the user to
enter data in textboxs. For example, the user must enter the weight of
a plate, the quantity, etc. How do I retrieve those values from the
textboxes so I can add them to a table or delete them from a table if
they already exist. Thanks for any help.
 
Hi,
Use a bound form. Access then handles writing to the table for you.
You can use the wizard to create your form, just choose a table to bind your form to.

To do it manually with your existing form, open it in design view, and in the
form's properties sheet under the Data tab, click in the Record Source property
and select your table.
Then for each text box, select the correct field for it's Control Source.
 
A form that use controls bound to fields in a tables/query record source,
will automatically save a record (and all its field values) every time you
move to a different record or close the form. Use the form wizard to create
a new test form; follow the prompts to pick a data source and pick fields.
Open that form in design mode and examine just how it is defined; make yours
similar, or you might just want to start over.
-Ed
 
Back
Top