Open form to blank form elements?

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 wrote:
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.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

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.

--
Steve Schapel, Microsoft Access MVP


Rick Brandt wrote:

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