Open form to blank form elements?

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

Guest

Good Day All,

I have a form I use to lookup items in my tblinventory. when I open the
form from my switchboard, I want it to open up "blank", then I can use my cmd
buttons to perform my searches or lookups?

Any ideas?

Brook
 
Brook said:
Good Day All,

I have a form I use to lookup items in my tblinventory. when I open
the
form from my switchboard, I want it to open up "blank", then I can
use my cmd buttons to perform my searches or lookups?

Any ideas?

Brook

So open it in DataEntry mode. Use the acFormAdd argument of the OpenForm
method.
 
Brook,

... or, use this:
DoCmd.GoToRecord , , acNewRecord
.... in your code when the form is opened. One difference between this
and the idea suggested by Rick is whether you want to be able to scroll
back through the existing records.
 
Back
Top