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

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






More information about the AccessD mailing list