[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