Jim Hewson
JHewson at karta.com
Tue Jan 10 15:46:37 CST 2006
Use the same filter (query) for the combo box as the form. Refresh the form after you set the filter. The filter will apply both to the form and the combo box. Jim jhewson at karta.com -----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 2:34 PM To: accessd at databaseadvisors.com Subject: [AccessD] Filtering a combo box Hi Group, This is another one of my simple minded questions. I haven't asked on in awhile, so I'm hoping that you will indulge me. All I want to do is filter a combo box's values when the records on my form are in a filtered state. In other words, I want to apply the same filter to both the records on my form as well as the combo box that allows the user to search for a record. 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