-
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
-
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...
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC]
Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|