By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,661 Members | 779 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,661 IT Pros & Developers. It's quick & easy.

opening a blank form

P: 7
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.
Jul 10 '08 #1
Share this Question
Share on Google+
2 Replies


P: 5
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
Jul 14 '08 #2

P: 15
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?
Jul 21 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.