[AccessD] A2003: Unbound form Question (He asks as he ducks)

I have done this on an unbound form with a getrows on the recordset to 
move all fields into an array
then use a couple of command buttons to scroll through the array. the 
command button moving
the next 5 records fields to controls on a form from the array. I used 
this to display multiple images on a continuous form.
Doesn't help much if you want to edit fields though or if you have large 
recordsets..

Darren Dick wrote:

>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
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada