[AccessD] Clearing form for next entry

Gina:

If it's a bound form can't you just GoTo acNewRecord after the data in the
form is saved?

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com


----- Original Message ----- 
From: "Gina Hoopes" <hoopesg at hotmail.com>
To: <AccessD at databaseadvisors.com>
Sent: Monday, October 04, 2004 8:59 AM
Subject: [AccessD] Clearing form for next entry


> I have a form set up to gather information about bank deposits. The user
> enters in all of one type of deposit, then needs to clear the form and
start
> over for the next type of deposit. I hate to maker her close and repoen
the
> form just to clear it out. I've got a procedure that archives all of the
> records to a history folder but I can't figure out how to keep the screen
> from showing #Deleted# in all of the fields once the table gets cleared
out
> to accept the new deposit. I tried turning off the Echo but it didn't do a
> thing, and I've tried a Requery but no luck. For a couple of business-rule
> reasons I can't just put a new field in for "deposit type", we actually
need
> to clear the table and process the data and give them a clean form for the
> next deposit. Can someone tell me where I'm screwing up?
>
> Thanks,
> Gina
>
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today - it's FREE!
> hthttp://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>