[AccessD] How do I refer to controls in an ADP

Thanks Arthur

I am just 'testing' at the moment - Never done an ADP

Basically I have 2 combos. The first has an item selected then the 'query I am
speaking about will be come the recordset for the second one - based on what the
user selected in the first

Simple in VBA

Can this be done - I'd just like to know how it is done?

If you have a better or more elegant way that allows for re-use I'd love to see
it too please 

How do I bind any recordset from a Static Function to anything on an ADP -
Combo, Page etc

Anything

Many thanks

Darren
------------------
T: 0424 696 433

-----Original Message-----
From: artful at rogers.com [mailto:artful at rogers.com] 
Sent: Tuesday, 13 February 2007 7:46 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How do I refer to controls in an ADP

As for me, I don't like queries that refer specifically to a given form's
controls, since they cannot be run without that form being open. I like to use
static functions for this. JWC prefers to use a class. Either way, you gain the
freedom from form-binding and thus can use the query in numerous contexts,
without depending on the form.
 
Arthur 

----- Original Message ----
From: Darren DICK <darrend at nimble.com.au>
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Sent: Monday, February 12, 2007 11:46:36 PM
Subject: [AccessD] How do I refer to controls in an ADP


Hi all

Normally in the Criteria for a query I would type something like
Forms!frmCoolForm!txtSomeControl 

What would I type in the criteria of a query to refer to an ADP?
Pages!pgCoolPage!txtSomeControl won't work

Any suggestions?

Thanks
DD
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com