[AccessD] Subform => New Record first?

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





More information about the AccessD mailing list