Defaulting to blank record

Bee*

Registered User.
Local time
Today, 09:52
Joined
Aug 22, 2007
Messages
12
Hi, I have a question regarding a form I'm trying to build.

Its a typical form where I add data to a table.

However, I basically want this form to open with all the fields blank, so that the form defaults to the blank final row of the table. Therefore the user can enter data from the word go and then hit a button to update it into the table (I can do the button part).

In order for this to work I would also need the arrow buttons which allow the user to browse between records to be removed from the form.

Can anyone give advice on how this is done? Arrow buttons removed and form defaulted to blank record is what I'm after.

Many thanks.
 
to open the form to a new record, put

DoCmd.GoToRecord , , acNewRec

in the onload event procedure of the form

to remove the other arrows you will have to do that from within the form properties. turn record selectors to NO
 

Users who are viewing this thread

Back
Top Bottom