[AccessD] Clearing form for next entry

Just put a me.requery in the afterdelete method.

John W. Colby
www.ColbyConsulting.com 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gina Hoopes
Sent: Monday, October 04, 2004 11:59 AM
To: AccessD at databaseadvisors.com
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