Form with a table used for data entry

[blurk]

I want to create a form that allows the user to add data to a single table. I want to do it this way so that I can allow the user to add data in mass, without giving them access to the entire table. I want them to be able to enter data for only some of the fields on the actual table.



For example, let's say I have a table with fields for product name, product number, order number, order date, order status and return date. I want the user to utilize this form to add a bunch of records to the table, but only fill out the first four fields. I imagine the form would have the table (with only a few columns) and a button to add the data from the form table, to the actual table.

Any ideas?

[ssanfu]

What you are asking for is database 101. Have you gone through any tutorials?
Here is one to start with
http://www.rogersaccesslibrary.com/forum/forum46.html

I want to do it this way so that I can allow the user to add data in mass

What do you mean by this? Importing data?