John Colby
jcolby at colbyconsulting.com
Fri Oct 24 11:23:16 CDT 2003
I kinda prefer that to leaving unbound controls on the parent form. This way the data entry fields would travel with the subform so to speak. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark A Matte Sent: Friday, October 24, 2003 11:45 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Subform => New Record first? Hello All, Not a pretty solution...but could you set up the header of the subform for data entry(make it look like an empty an empty record) and use the body of the subform just to display the records sorted whatever way you want? When they click save...it blanks the header and refreshes the body so it looks like the are just adding to the top? Mark >From: "John Colby" <jcolby at colbyconsulting.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: "Access Developers discussion and problem >solving"<accessd at databaseadvisors.com> >Subject: RE: [AccessD] Subform => New Record first? >Date: Fri, 24 Oct 2003 09:49:16 -0400 > >LOL. Everybody wants this. It definitely isn't possible strictly within >Access using built in properties. > >John W. Colby >www.colbyconsulting.com > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Sad Der >Sent: Friday, October 24, 2003 9:35 AM >To: Acces User Group >Subject: [AccessD] Subform => New Record first? > > >Hi group, > >I've got a subform. When I scroll through the records >it is possible to add a record. However I first have >to tab through all records (or use the scrollbar). > >Is it possible to have the new line (to insert a new >record) appear on top (as the first line)? > >So you see an empty line and below it are all >detailrecords. > >Hope this makes sence. > >TIA > >SD > >__________________________________ >Do you Yahoo!? >The New Yahoo! Shopping - with improved product search >http://shopping.yahoo.com >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com > > > >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _________________________________________________________________ Cheer a special someone with a fun Halloween eCard from American Greetings! Go to http://www.msn.americangreetings.com/index_msn.pd?source=msne134 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com