How do I use submit button to add details to a table?

[cwright]

Hi everyone, I am new to this so bear with me.

I currently have a form with textboxes and 2 combo boxes. I have a submit button at the bottom of the page and would like this to take all the infomation from the form and add to a master table.

I was hoping to be able to create a pop up message to say "This item has been added to the database"

Can anyone help point me in the right direction?

Many Thanks!

 

[aleb]

Now create an append query. In design of this query in "field" grid type something like this
1: Forms!Yourformname!Yourcomboname
Do so for every other field you need. Save a query
In "append to" select the field into which you will append this data.
Now on the form put the button (use wizard to do so), wizard will ask you what type of action you want, select "miscelenious" and from there select "run query", select the name of the query which you have just created.
This is it