Elam, Debbie
DElam at jenkens.com
Wed Jun 21 09:38:21 CDT 2006
I assume you will looking up records using a different button than one that would be used to enter records. You may want to change the query for the combo box in the code that opens the form. Add this just after the form opens Me!MyInstructorComboName.RowSource = "Query with all or active only" Debbie -----Original Message----- From: Lavsa, Rich [mailto:Rich_Lavsa at pghcorning.com] Sent: Wednesday, June 21, 2006 9:18 AM To: Access Developers discussion and problem solving; ACCESS-L at PEACH.EASE.LSOFT.COM Subject: [AccessD] Show description of non active item in listbox/combobox Hello all, I have an application where I created for example a table that holds names and some details of instructors. I also have an Active field Y or N. The combobox will only display instructors who are marked with Y. Yet this will allow you to maintain all your reporting for historical data. The issue that comes into play when in the entry form, for a particular employee that took training, in looking at the detail records of their training, if they happened to take a class/session that was taught by an instructor that isn't active any longer there isn't any Name displayed in the form because the combobox will not retrieve this information. Does anyone have a solution for this? I in the past I have put 2 combobox's side by side and shrunk the one down so that only the button is displayed which is then placed directly over the full size combobox button. The shrunken button has the criteria in it to only retrieve the Y's, however the full size combo can retrieve everything, so on the screen everything looks ok and seems to function ok. This approach doubles the combobox's, and doubles the maintenance if anything changes in the lookup tables. Hoping someone has a better way to handle this situation. Thanks in advance for any tips/tricks/ideas... Rich -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com - JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject to the Attorney-Client Privilege, (2) an attorney work product, or (3) strictly confidential. If you are not the intended recipient of this message, you may not disclose, print, copy or disseminate this information. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law. This communication does not reflect an intention by the sender or the sender's client or principal to conduct a transaction or make any agreement by electronic means. Nothing contained in this message or in any attachment shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions.