How do i create a form where you input data?

[faiza1808]

I need to make a form where I can input data that will automatically add to the table. I have the form in design view but I dont know how to make it so its blank and I can enter the data and it would add on?

what would I need... do i need a append query? If I do then how?

 

[missinglinq]

Assuming that you already have created a table, which should be done first, the simpliest way is to use the Form Wizard to create the form. The form controls will be automatically bound to the table fields and you're set. If you want to make cosmetic changes to the form, you can do so by entering Form Design View and making the modifications.

Linq ;0)>

 

[faiza1808]

I've done the form in the form wizard. I'm actually stuck on the modifications part. I want to make it ...so I can input data into the form.. so the fields should all come blank..... I should be able to enter data into it and the data should automatically append to the table.

kinda like a manual form for lets say to enter a competition... but actually on a form in access

 

[missinglinq]

If you've used the Form Wizard and the controls are bound to fields in the underlying table, which they are in a Wizard generated form, the data will be saved to the table, automatically, when you

• Close the form
• Move to another new or existing record
• Explicitly save the record with a custom 'save' button

When moving to a new record the fields will all become blank, assuming, once again, that they are bound to fields in the underlying table, without any intervention on your part.

Linq ;0)>