When adding to a form, how do I...

[C.S.]

I have a form in Access that adds to the corresponding table.

Currently when I open the form, it takes me to the first record in the table; and I have to cycle through all recors to get to a blank one to enter new data.

How can I make it so that the form opens up to blank fields without having to cycle through them? (I'm extremely new to this, with limited VB skills, so precise examples would be appreciated)


Thank you for your time.

[CoMMiE]

try this c.s

Private Sub Form_Load()
'assuming that text1.text is the field for entering data
text1.text=" "


End Sub

hope that helps

[Dr_Evil]

Add this to you Form_Load event by opening you form and clicking "Code" on the View menu.

Private Sub Form_Load()
    Form.Recordset.AddNew
End Sub

If you need any more help just post & I'll see what I can do.