Use Form to Enter Data into a Table

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

Golfinray

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

ryguy7272

Thanks for the inforamtion. Seems pretty easy, now that I think about it!
Regards,
Ryan---
 

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

Top