HELP!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need some help! We have a database that we input patients informaiton into. When you click on new patient it opens up with the data fields empty. NOW when we open the patient form, it has all the data fields filled in....Is there a way to have the form open up to be blank and when we enter data in to the form and save and close it. When we open it up we would like the data fields to be empty

Any suggestions??

Thanks
Darci
 
In the Form's Load eventHandler, put
DoCmd.GoToRecord , , acNewRec

In it's AfterUpdate eventHandler, put
DoCmd.Close acForm, Me.Name

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
I need some help! We have a database that we input
Click to expand...
patients informaiton into. When you click on new patient it
opens up with the data fields empty. NOW when we open the
patient form, it has all the data fields filled in....Is
there a way to have the form open up to be blank and when
we enter data in to the form and save and close it. When
we open it up we would like the data fields to be empty.
 
you could use this code to open

DoCmd.OpenForm formName, , , , acFormAdd


I need some help! We have a database that we input patients informaiton
into. When you click on new patient it opens up with the data fields empty.
NOW when we open the patient form, it has all the data fields filled
in....Is there a way to have the form open up to be blank and when we enter
data in to the form and save and close it. When we open it up we would like
the data fields to be empty.

Any suggestions???

Thanks,
Darci
 
Hi Darci,
In the form properties, set the DATA ENTRY event
to YES

Hope This Helps
-----Original Message-----
I need some help! We have a database that we input
Click to expand...
patients informaiton into. When you click on new patient
it opens up with the data fields empty. NOW when we open
the patient form, it has all the data fields filled
in....Is there a way to have the form open up to be blank
and when we enter data in to the form and save and close
it. When we open it up we would like the data fields to
be empty.
 
Back
Top