opening a blank form

[awigren]

I am in the process of creating a database for some lab information at work. I have already imported all the information from the previous excel file and it is in the database now.

Right now when I open up my first form it shows me all the information in from the first record in the table. I need to know if there is a way to have my first form open up blank, so that I can just begin adding a new record that will be added after the last record when I hit save.

Thank you very much.

[alkeshnayak]

Make Clear1 Procedure

Public Sub Clear1()
Dim Otext As Object
For Each Otext In Me.Controls
If Typeof Otext Is TextBox Then Otext.Text=""
Next
End SUB


You Can Use This Procedure Whenever You Want Clear All Textbox In The Active Form

[IceBower]

Make Clear1 Procedure

Public Sub Clear1()
Dim Otext As Object
For Each Otext In Me.Controls
If Typeof Otext Is TextBox Then Otext.Text=""
Next
End SUB


You Can Use This Procedure Whenever You Want Clear All Textbox In The Active Form

Alkeshnayak,

If they are using bound fields (which this sounds like they are). Wouldnt this risk deleting the data from the first record ratehr then creating a new one?