Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-12-2008, 07:31 PM   #1
shevo
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
wazz
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
AWF VIP
 
RuralGuy's Avatar
 
Join Date: Jul 2005
Location: @ 8300' in the Colorado Rockies
Posts: 13,820
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
Reply

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 12:18 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
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