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