[AccessD] Changing Combo Box Data Source

How is that the "correct" way?  The OnEnter event occurs when the control
receives focus and the OnExit event occurs when the control loses focus.

You suggested solution would have records always UNFILTERED with no way to
FILTER them because as soon as the user leaves the combo to do something to
a filtered record, the records would unfilter again.

Doris Manning
Database Administrator
Hargrove Inc.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby
Sent: Friday, July 15, 2005 1:45 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Changing Combo Box Data Source

The "correct" way to handle this is to have a query that shows ALL records
(UNFILTERED) and another that shows FILTERED records.  In OnEnter, change
the query to the FILTERED query, in OnExit change the query to the
UNFILTERED query.

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 Nicholson, Karen
Sent: Friday, July 15, 2005 1:32 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Changing Combo Box Data Source


I know there is a way to do this.  Where are the Friday Jokes?  My form
opens.  The combo box on the form is filtering for only "Open" items.
However, PIA user wants the option to see all projects, open and closed.
What code do I throw on a button to change the record source of the combo
box to take off the filter?  Is it setting the recordset?  Thanks.
-- 
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