how to get information from a form to save in a table

fakiane

New member
Local time
Today, 04:22
Joined
Dec 14, 2016
Messages
8
I'm making a stock control database and want the information from the supplier and products forms to be saved into the corresponding tables using a button.
Any idea on how to do it please??
 
build the forms, use the FORM WIZARD,
pick the table ,supplier
add fields.
done.

create a 'menu' form.
put 2 buttons on the form,
1 to open the supplier form
1 to open the product form.

set the frmMainMenu to open when the database opens,
then user can pick which form to use.
 
build the forms, use the FORM WIZARD,
pick the table ,supplier
add fields.
done.

create a 'menu' form.
put 2 buttons on the form,
1 to open the supplier form
1 to open the product form.

set the frmMainMenu to open when the database opens,
then user can pick which form to use.

I already have all that in my database, but how is that going to help me save information inputted into the forms into the tables?
 
The forms are "Bound" to the table. Anything you type into the form will automatically be saved when you move from one record to the next. This is one of the advantages of bound forms.
 
fakiane,

Tell us about your database --the things you do in your business in simple terms.
Also, capture a printScreen of your tables and relationships and post a jpg in zip format.

This material from Allen Browne has information on Inventory and Stock taking.

Here is a generic data model for Inventory management from Barry Williams. It may give you some ideas for tables and relationships.

You may get some insight from this youtube video on Stock control.

Inventory management is not a trivial subject.
Good luck.
 
Last edited:
This is basic Access 101.
Forms save data into tables.
 

Users who are viewing this thread

Back
Top Bottom