Use Form to Enter Data into a Table

  • Thread starter Thread starter ryguy7272
  • Start date Start date
R

ryguy7272

I would like to know if there are some good resources on the web that explain
how, and when, to use a Form to collect data from a user and input it into a
Table. I am kind of weak with Forms, but know Tables, Queries, Reports, and
Macros pretty well. I’ve used Forms many times before, but only for viewing
data, not as a template for capturing data. I know it can be done, and maybe
it is even easy, but after experimenting with a few things during the past
few days, I have not been very successful in my endeavors. If anyone knows
of a good online tutorial, or some good web-based system for showing how this
is done, please let me know.

Regards,
Ryan---
 
If you build a form based on a table, it should save data to the table. If
you base a from on a query unless you enforce referential integrity and have
your indexes right it may not. You could, if necessary, just build an update
query to update the table from the query.
 
Thanks for the inforamtion. Seems pretty easy, now that I think about it!
Regards,
Ryan---
 
Back
Top