Custom Entry Form

[thsoundman]

Hey all! hope you all are having a good day. Just a quick question I currently have whats shown in the picture. Plus a submit button. What I want to do is add 8 fields that the user can enter data into. qty, start, finish, etc etc etc. I can't figure out how to link them to the table and then on top of that make the submit button send the data to the table. I also don't want them to view previous records. I'm making a seperate page for that. If you need more information feel free to let me know!

 

[odin1701]

You will need to run a SQL INSERT INTO statement when the submit button is pressed:

Do something like:

strSQL = "INSERT INTO [table name] (Field_1, Field_2....) VALUES (formtextbox1.value, formtextbox2.value....);

DoCmd.RunSQL strSQL

Then set all the fields on your form to be blank again.

This way the form doesn't need to be bound to a table, and you will only be able to add data, not view.

If you link the form to the table, you won't need to "submit" the data. It will update the records automatically.

 

[Bob Miller]

The first thing to do is set the forms source as the table or a query of the table where you store the data. In design view, do this by moving the mouse pointer over the icons in the Form Design toolbar until you see properties. Select this icon and add the table/query in the Record souce field.
Next, you will see an icon in the form design toolbar that says Field list when you hover the mouse pointer over it. Click it and your fields will be listed. Click and hold the left mouse button over a field and drag it to where you want it on the form.
You do not need a Submit button as the data is stored in the fields as it is entered in the form.
Also, in the forms properties set the Default view to Single forms and the Data entry to Yes.

 

[thsoundman]

I want the submit button because it will force the user to think about the data they have entered. I want them to have to physically do somthing before the data gets entered not just them pressing enter.

 

[thsoundman]

Clearing form data

Ok say that I want a clear data/reset button on the form. How would I do that. Basicaly if someone enters all the data incorrectly I would like there to be a reset button so they can clear all the data fields simultaniously.