MS Access Question - Forms and Tables...

[Superwormy]

OK, so say I make a form in Access ( 97 if that matters ), I want people to be able to fill in the form, click the ' Submit ' button and have all the data they entered by stuck into the ' vendors ' table.

How do I do it?



This is so easy with HTML and PHP... :-(

 

[Zaphs]

Build the fields on your form to have their control source linked to the fields in the vendors form you want to update. (look at the properties of each of the text boxes that you make, this is where you'll find the reference to the control source)

Then, when you make the submit button on your page, the button wizard will pop up. Make the action of the record "add new record".

Now, when you enter in text in the fields, then text will automatically be put into the vendors table. When you hit submit you save those changes to the vendors table and you have a blank form again.