[AccessD] Hide Field Once New Record is Saved

Heenan, Lambert Lambert.Heenan at AIG.com
Wed Nov 26 09:16:20 CST 2003


In the form's OnCurrent event...
	
	YourField.Visible = Not NewRecord

Then do exactly the same thing in the AfterInsert event which will handle
cases where the record is saved but remains current.

Lambert

> -----Original Message-----
> From:	Lonnie Johnson [SMTP:prodevmg at yahoo.com]
> Sent:	Wednesday, November 26, 2003 9:59 AM
> To:	Access Developers discussion and problem solving
> Subject:	[AccessD] Hide Field Once New Record is Saved
> 
> 
> 
> I have a form that is used for new records and modifying existing records.
> I want a field to be visible when a user enters a new record then hide it
> from view once the new record has been saved.
> 
> My other thought was to make the field a modal pop up when entering new
> records. Based on the flow of the data entry being done, I would prefer my
> first choice.
> 
> Thanks to any and all responders!
> 
> 
> 
> Lonnie Johnson
> ProDev, Professional Development of MS Access Databases
> Visit me at ==> http://www.prodev.us
> 
> 
> 
> 
>  
> 
> 
> 
> 
> ---------------------------------
> Do you Yahoo!?
> Free Pop-Up Blocker - Get it now
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


More information about the AccessD mailing list