You don't set the onclick event to make a new record to a button on the form. That already opened with the first record of the table, as you saw.
You set it to a button outside the form to call a VBA-module that opens that form with a new record. The VBA-code is DoCmd.OpenForm myFormName, acNormal, , , acFormAdd
Kees
.
Hi Everyone,
I'm using microsoft access and i have a simple table called profiles with names, location, etc.
I have built a form to add new records to this table with a button and the onclick event set to new record.
Yet everytime i run the form it just replaces my first record with what i have entered then does not let me enter any new records at all.
I am new to access and macros and don't know much at all, so if its something simple i apologize.
Any help would be appreciated.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic