Populating a table using a form

[rnashting]

Good Morning!

I have created a form as well as a table, and would like to use the form to populate the table. I did not base the form off of the table, because I do not want the form to display any of the records from the table. The end goal is to give folks with very little computer literacy the ability to fill out a simple form and click a command button to add items to their inventory.

That being said, I am unsure of how to get the data from the form to the table. My thoughts are that I have to have the button create the record, and then set each field to what the form text captured, but I am unsure how to make the connection.

Any help that can be provided would be awesome.

Thanks!

[missinglinq]

You're talking about using an Unbound form, which means that you're talking about three to fours times as much development time as you would be if you used a Bound form (where the form is based on the table) which is how Access is really intended to be used. You're also talking about having extensive knowledge of Access, which doesn't appear to be the case here.

To easily do what you desire:

• Make a form based on your table; you can use the Forms Wizard if you like
• In the Form Properties, set the Data Entry Property to Yes

Now your users can enter data for a new record but cannot view any existing records.

Your thoughts?

Linq ;0)>

[rnashting]

That is much easier, but what concerns me is that all it takes for a new record to be added is the TAB button. Is there a way to disable that, and make them push a command button to enter the record?

[rnashting]

Plus, if they hit the back arrow it shows current records also...