I am new to this and I am having the following problem:
I am trying to get the user to enter information in text boxes (create a new record)and then save the new information to the underlying table. (using the On_Click())
What do I need to take the information from all 3 fields at the same time and save them to 1 record?

Also, how can I cancel the most recently entered record? (the record I just saved)
Thanks,
Angela

First create your table, then use the form wizard to create your form.

Access will bind the table to the form so that data changes are saved automatically.

To cancel a saved record, you have to navigate to the record (i.e.: find it), then delete it.

Hope this helps,

Peter De Baets
Peter's Software - MS Access Shareware and Freeware http://www.peterssoftware.com