[AccessD] Clearing form for next entry

Perfect! Thanks, Gustav!

Gina

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Monday, October 04, 2004 11:30 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Clearing form for next entry

Hi Gina

Try:

     With Me
       .Painting = False
       ' run your clean up code.
       .Requery
       .Painting = True
     End With

/gustav


 > 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?

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


Thanks,
Gina

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/