Clearing form after save

  • Thread starter Thread starter Nigel Reed
  • Start date Start date
N

Nigel Reed

Maybe I overlooked something (working with Access 2003 for the first
time today)...

I have added a "Save" button and would like the form to clear after the
user saves the data.

Also, if a user enters an item in the first field (which is the primary
key), how would I get Access to fill in the other fields if a record
existed with that value?

I'm sure it's in the help but it escapes me at the moment.

Thanks,
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.
 
1st question. After saving the data, you could enter code to go to a
new record. Something like: DoCmd.RunCommand acCmdRecordsGoToNew

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.

Hope this helps.
 
Penguin said:
1st question. After saving the data, you could enter code to go to a
new record. Something like: DoCmd.RunCommand acCmdRecordsGoToNew
Click to expand...

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.
Click to expand...

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.
Click to expand...

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.
 
Back
Top