Add data from a form to a table

[Guest]

I've developed a form where users enter data. Once the user is done, I'd
like to have that data added to a table through the use of an "enter" button
or something of that nature. Could someone tell me how that is done. Thanks!

 

[Lynn Trapp]

If you bind your form to a table (or a query from the table) it will do this
automatically.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Guest]

Hi Lynn - Thanks, that sounds like a winner. How do a bind the form to my
table? Also, several of the fields require manual input. Is there a way to
make sure the user enters all the data before it can be entered in the table?
Thanks for your help!

 

[Lynn Trapp]

Every form has a Record Source. You can make either a table or a query the
Record Source.

The easiest way to make sure all data has been entered is to make sure that
you set the Required property of the field to Yes. Other ways to ensure that
requires you to code something in VBA.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html