[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