Data transfer from Forms to tables.

Hi there, simple question:

How is the data which is input into a form stored in the relevant tables?

I have a feeling it's by using macros but I'm unsure.

If it is would it simply be the case of recording the copy and paste of data from the form to the table?

Look forward to your reply! Rushy

Quote:

---

Originally Posted by rushy-s

Hi there, simple question:

How is the data which is input into a form stored in the relevant tables?

I have a feeling it's by using macros but I'm unsure.

If it is would it simply be the case of recording the copy and paste of data from the form to the table?

Look forward to your reply! Rushy

---

In Acess, it is very easy to do. You set the form's property for record source to be the table you want use to store the data. For each control on the form, you set the control source property to the desired field. This is known as a "bound" form. There is NO code required to save the data. Access will automatically save the data when you leave the record.

You may want to also check out:
Access Basics

Hope this helps...