John W. Colby
jwcolby at colbyconsulting.com
Fri May 6 06:43:52 CDT 2005
What you are probably seeing is the LAST record, with all the rest off the screen at the top. Do a page up and see if you see the rest. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren Dick Sent: Thursday, May 05, 2005 11:46 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] A2003: Unbound form Question (He asks as he ducks) Excellent I get all that I now appreciate the diff between a late bound and an unbound form - thanks I am now (as you suggest) using standard naming so I can bind the controls at runtime - works OK What I am finding though, that only the one record (the first record) is displayed in the continuous form If there are say 6 recodes to display how do I get (using this late binding method) the form to show all 6 records etc? Many thanks for the reply DD -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Friday, 6 May 2005 1:01 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] A2003: Unbound form Question (He asks as he ducks) On 6 May 2005 at 12:12, Darren Dick wrote: > I am experimenting using a 'generic' unbound form If I can get it to > work I can get rid of 6 forms in my dB and replace them all with 1 > generic > > So I have never used 'em (unbound forms that is), so I am a complete > amateur. > > I am hoping to do all this using a continuous form - Don't know if > that matters so I am mentioning it now:~)) > Unbound and Continuous forms as mutually exclusive concepts. > What I intend doing is creating the desired recordset from a 'calling > form' and passing it to the generic form as the generic form's record > source. That's the easy bit I know how to do that. So it's not an unbound form - it is bound to a recordset. It's just that you are defining the recordset at run time rather than at design time > How then do I get the controls 'binding' to various fields in the > various tables Say I want txtGeneric1 on the generic form to display > rs!MemberID And then say txtGeneric2 to display rs!LastName etc Bind the form to SQL queries which use standard aliases for the fields. -- Stuart -- 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