Open Form with No Data showing

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

Guest

Howdy,

I am farily new to ACCESS and have been looking to see if this question has
already been anwered but could not find my particular case.

So here it goes,

I have a form that is only to do data edits and not to add new records and i
need it to open up with a blank form. i have a combo that is used to find the
particular record you are looking for but not new records will be added on
this form.

All of the answers I have seen so far say to use:

"DoCmd.GoToRecord acForm, Me.Name, acNewRecord"

in order to get the form blank at start up. But I beleive this will create
a new record each time it opens and I do not want a person to even put in
something that could create a new record. Anyone help?

As always THANKS in Advance!!!!
Chip
 
A bank form is the same as a new form.

Either let it default to a form, or pop up a message box before the form
ever opens and ask the user which record he wants to default to.

If you don't want to allow adds, then you can't go to a blank (New) record.
 
Back
Top