Form to enter new record.

[chriss_ko]

I have a form that i use to enter record to a table but the problem is i want when you first open the form to display area to enter new record without you clicking the button to add new record.

help plzz..

 

[Catalina]

In the properties of the form, on the Data Tab set Data entry to Yes.

Catalina

 

[missinglinq]

As I said, elsewhere, to have the Form open on a New Record and be able to view Existing Records, leave Data Entry = No and use this code:

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

Just depends on your exact needs.

Linq ;0)>