Hi,

I am using access as a front end and backend for an application.There
are few things i need assistance:

1.I have a form with a few text fields which is used for adding new
users.
after adding a user i want all the controls to get cleared.

2.I would like to now how will go to another form when u want to go to
another form.I am using the visible property to false and visible=true
for the form i need to show.I know this is not the correct method,but
cannot figure out the correct one.

3.How can i use a timer object as in VB.I need a label to be show for
10sec ,i also need a form to go to another form after after showing a
label for 10sec.


I would like to get some hel on these .Thanks in advance.

mickykt

Hello Mickykt,
Hey you need to be a bit more clear, what do you mean by saying clear
all the controls? say you have txtBox1 as a textbox in your form
called form1, then to clear the textbox when you click on the submit
button you have to have something like( sy I have submit button
called "cmdOK"):

Private Sub cmdOK_Click()
txtBox1.text =""
End Sub

If you have a control array you coould use a for loop to clear all
controls

2) Sy you have two forms, form1 and form 2, say you want to load form2
from form1 then you do something like this:
Private Sub cmdOK_Click()
form2.show
Unload Me
End sub

Hope this helps.
Yegnaram Iyer
www.geocities.com/yegnaramiyer
michael.koshy (AT) pacfusion (DOT) com (mickykt) wrote in message news:<da129102.0309150156.5ed2487 (AT) posting (DOT) google.com>...