Add Name to Table thru Form

[DeeDee]

I'm sort of new to Access, so this is probably very simple. I need a form where the administrator can type a name into a text box and click OK. That name in the text box will go to the end of the list in the Table "tblRequestor". There are two fields RequestorID (primary key and set to autonumber) and RequestMadeBy (where name goes). I want this so we're not actually dealing with the table itself. Thanks in advance for any help.

 

[kathryn]

My recommendation is to create a form using the Form Wizard. Click on the form tab in the database window and choose New... Then choose Form Wizard from the list box and select tblRequestor from the combobox. Click next and the Form wizard will step you through the process.

Post if you have problems.

Kathryn