Re: Clearing form after save

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Nigel Reed (see_at_www.nelgin.nu-slash-qconfirm.html)
Date: 02/12/05 

Date: Fri, 11 Feb 2005 22:35:50 -0600

Penguin <caseythepenguin@yahoo.com> wrote:
> 1st question. After saving the data, you could enter code to go to a
> new record. Something like: DoCmd.RunCommand acCmdRecordsGoToNew

I managed to just add the following into the click_save function

DoCmd.GoToRecord , , acNewRec

> 2nd question. Try using a combo box. This will show existing data and
> if its new data you can add the entry using the NotInList property.

Ok, I'll give that a try. Thanks. I'm going to get an Access 2003 book
from the library to help me through a few other things.

> Hope this helps.

Yeah, it does. Thanks for taking the time to repsond.

Regards
Nigel 

-- 
www.myoldcontacts.com - Tell your friends to tell their friends
www.sysadmininc.com  - Consultancy, Service, Sales, Networking...
www.british-expats.com - Connect with British Expats World Wide
www.kxez.com/shows_britishinvasion.php - 9-11pm Sunday. KXEZ 92.1 FM
"I reject your reality and substitute it with my own" --Adam Savage.

Relevant Pages

  • Re: Here!!
    ... On 9/29/2011 3:00 PM, BessieBee wrote: ... 153360 cigarettes not smoked, saving $19,170.00. ... I don't think I'd still be here to enjoy my son and his girlfriend destroying the kitchen while making biscotti, or bitching about the hours and hours of homework they have, or to enjoy their excitement as they get ready to march with Marching Mizzou before a home game, or as Mollie gets ready for a visit from her only sister, or Kevin bursting with pride as he talks about "educating" the pledges of his fraternity, or their tears still after the car death accident of two of their best friends this summer, or..... ...
    (alt.support.stop-smoking)
  • Need a shell or perl script
    ... and have been saving lots of old personal emails. ... having kept all these different mailboxes in one directory. ... addresses have become invalid over the years and some friends' addresses ...
    (Debian-User)
  • Re: posted appointments show up 1 hour earlier when viewing on pro
    ... "Friends of th e Penguin" ... That means the time zone updates that changed the DST date to the second Sunday of March were not applied to one of the systems in the mix, most likely the one where Outlook is running. ... Brian Tillman [MVP-Outlook] ...
    (microsoft.public.outlook.calendaring)