Charlotte Foust
cfoust at infostatsystems.com
Tue Jan 10 15:46:33 CST 2006
In that case, assuming you're applying a filter to the form, you can get the filterstring for the form. Then assuming your combobox has a SELECT statement as a rowsource and you have the default "all records" rowsource for the combobox stored in a constant in the form, you can just add the filterstring as a where clause and set the rowsource to the new SQL statement. When you want to show all, just set the rowsource back to the default select string. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Julie Reardon-Taylor Sent: Tuesday, January 10, 2006 1:17 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Filtering a combo box Yes. Definitely. Julie Reardon-Taylor PRO-SOFT OF NY, INC. 44 Public Square Suite #5 Watertown, NY 13601 Phone/Fax: (315) 785-0319 www.pro-soft.net NYS IT Services Contract CMT026A NYS Certified Woman-Owned Business -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com