On Thu, 7 Aug 2008 10:26:01 -0700, advanced dabbler <advanced
dabbler@[EMAIL PROTECTED]
> wrote:
>I have a sales database that I'm building to keep track of sales
functions,
>contacts, etc. I have one form that has multiple drop-downs based on
data I
>supplied and not a table/query etc. It also has yes/no check boxes. I
need
>everything to reset when the form is opened and when a new record is
added so
>that nobody accidentally uses information input by the previous user. I
>don't know if that makes sense, but, if someone can figure it
out.....please
>let me know.
>
>Thanks!
What is the Form's Recordsource? If it's the table into which you're
putting
data - or a query based on the table - you can simply move to the "new
record"
by pressing the *> navigation button, or creating your own button to do
so. It
should not be necessary to blank out any existing data, because the form
should only SHOW the existing data - and there isn't any data in the blank
"new record".
You can put code or a macro in the form's Load event to move to the new
record.
--
John W. Vinson [MVP]
|
