Making a form cmd button add records to a table

[stuwage]

I'm pretty new to Access, so this may be an easy question:

I use Access 2003. I've got a form with a bunch of fields pulled from various tables. If I wanted to put a command button on that form to add the data from the fields on this form to append to a seperate table, how do I do this?

I've gone through the wizard when adding a command button to the form, and I can't see anything that gives me this option.

Any help is greatly appreciated.

 

[TheAceMan1]

How are ya stuwage . . . . .

Before you get too far, have a look at the following:

Normalizing Tables

Table Relationships

Fundamentals of Relational Database Design

See Ya! . . . . . .