Kath Pelletti
KP at sdsonline.net
Thu Aug 4 18:33:36 CDT 2005
Maybe Susan means that the users would like to have a 'search function' which will find something anywhere in the database. I have had that request before, eg. for a database that tracked travel agent wholesalers, travel agent retailers, suppliers, clients etc. Users would get an inquiry from someone and wanted to type in their name and find all instances anywhere in the system. It depends whether you need to populate a combo or not. In my case I created an unbound text box and users type in any part of the person's surname and hit enter. The code then searches through the relevant tables one by one and populates a results table. Kath ----- Original Message ----- From: Charlotte Foust To: Access Developers discussion and problem solving Sent: Friday, August 05, 2005 6:20 AM Subject: RE: [AccessD] "Find" combo box searches more than one table Sorry, but I don't understand the question. A "find" combobox works on a form and you populate it with a list that has some relationship to the current recordset of the form. Then you use the indicated record to move in that recordset. I can't see how (or why) you would use a find combo to look somewhere other than in the form's recordset. Charlotte Foust -----Original Message----- From: Klos, Susan [mailto:Susan.Klos at fldoe.org] Sent: Thursday, August 04, 2005 12:29 PM To: accessd at databaseadvisors.com Subject: [AccessD] "Find" combo box searches more than one table Is it possible to construct a "find" combo box that will search through more than one table in the database? Susan Klos Senior Database Analyst Evaluation and Reporting Florida Department of Education 850-245-0708 sc 205-0708 -- 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