Go Back   Access World Forums > Microsoft Access Discussion > General

Thread Tools Rate Thread Display Modes
Old 03-12-2008, 07:31 PM   #1
Registered User
Join Date: Jun 2007
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
shevo is on a distinguished road
Event for adding new record

What is the form event for adding of new records?
I want to make some fields disappear to prevent user input when the user enter a new record.

shevo is offline   Reply With Quote
Old 03-13-2008, 01:20 AM   #2
Super Moderator
wazz's Avatar
Join Date: Jun 2004
Location: Vancouver, BC, Canada.
Posts: 1,711
Thanks: 0
Thanked 3 Times in 3 Posts
wazz will become famous soon enough
you could use the afterupdate event.
Access 2003 / XP Pro
"We draw our own designs
But fortune has to make that frame." - N. Peart

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
wazz is offline   Reply With Quote
Old 03-13-2008, 05:01 AM   #3
RuralGuy's Avatar
Join Date: Jul 2005
Location: @ 8300' in the Colorado Rockies
Posts: 13,821
Thanks: 7
Thanked 311 Times in 301 Posts
RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice RuralGuy is just really nice
You may want the Current event with Me.NewRecord = True

(RG for short) aka Allan Bunch Previous MS Access MVP acXP, ac07, ac10, ac13 - WinXP Pro, Win7 Pro, Win10 Pro
Please post back to this Forum so all may benefit.
Teaching is not filling a bucket but lighting a fire.
RuralGuy is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with MouseTrap sample after securing database sara82 Forms 7 10-14-2005 10:01 AM
Detect duplicate record before entering sierra467 Forms 4 08-19-2005 08:32 AM
Event on Record Change yippie_ky_yay Forms 2 11-05-2003 11:48 AM
before update event > save record? krisleech Modules & VBA 6 03-12-2003 03:27 AM
Cancel event is saving the record, anyway. ahvc Forms 7 09-10-2002 07:32 PM

All times are GMT -8. The time now is 02:51 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World