Form empty by defeault

[miicker]

Hello,
I have a DB, and I've created a from. I want the form to be blank by default, but I want allow users to browse trough records anyway.

So what i've done:
In the form properties I've set ''Data Entry'' to ''Yes''.
This worked so far, the form is now blank by default.

I've putted in buttons that allows users to browse trough records, those buttons do not work any more.

So is there a button that opens the first record, so that the navigation buttons work again, if you know what I mean.



Kind regards,

Miicker

[Missinglinq]

Common sense would dictate that Data Entry would need to be set to 'Yes/True' in order to... enter data, but of course, this is not true! When Data Entry is set to Yes you can only enter New Records, not view existing Records, as you've found out. Set Data Entry back to No, then use this code:

Private Sub Form_Load()
 DoCmd.GoToRecord , , acNewRec
End Sub

It'll now open to a new, blank Record, but the user can also click on your custom Nav Buttons and go to First Record, Previous Record, or whatever.

Linq ;0)>