end of record

[record via AccessMonster.com]

how can we do this in ms access?..what we want is that when the form loads
all the fields are set to blank and not the fields with the previous records.
We want the form to be ready to be filled for a new record.

On what we are currently doing when the form loads it shows the previous
records so we need to click the add button just to add new records and thats
what we dont want to do.

 

[Allen Browne]

Set the fom's Data Entry property to Yes.
It will then load to a new record, without the previous ones.

If you are opening the form programmatically, use:
DoCmd.OpenForm "Form1", DataMode:=acFormAdd

If you want it to load all the previous records, but still go to a new one,
add this code to the Load event procedure of the form:
If Not Me.NewRecord Then
RunCommand acCmdRecordsGotoNew
End If