Elam, Debbie
DElam at jenkens.com
Wed May 28 07:43:37 CDT 2003
My first thought is to check for typos. I use the query builder to insert the name of the first combo box to make sure I did not mess it up slightly. I can't think of anything else right off. Debbie -----Original Message----- From: Tesiny, Ed [mailto:EdTesiny at oasas.state.ny.us] Sent: Tuesday, May 27, 2003 2:53 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Help with Combo Box Debbie, I added ComplaintSpecificCode to the query and bound on this column. It saved the correct value but a parameter box still pops up. Any idea why? Ed Tesiny EdTesiny at oasas.state.ny.us -----Original Message----- From: Tesiny, Ed Sent: Tuesday, May 27, 2003 3:46 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Help with Combo Box Ooops, your right, bound to column 1. Ed Tesiny EdTesiny at oasas.state.ny.us -----Original Message----- From: Elam, Debbie [mailto:DElam at jenkens.com] Sent: Tuesday, May 27, 2003 3:33 PM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] Help with Combo Box What is your bound column. By default this query will bind ConplaintGeneralCode, which is the value from the first combo box. Debbie -----Original Message----- From: Tesiny, Ed [mailto:EdTesiny at oasas.state.ny.us] Sent: Tuesday, May 27, 2003 2:28 PM To: accessd at databaseadvisors.com Subject: [AccessD] Help with Combo Box I have two combo boxes and I'm trying to limit the contents of the second combo box based on the selection made in the first box. I'm obviously doing something wrong because the second combo box saving the value of the first box in the table. For the Row Source of the 2nd combo box I have: SELECT ComplaintGeneralCode, ComplaintSpecificDesc FROM tblComplaintSpecific WHERE ComplaintGeneralCode = Forms!SF_Complaints_New!cboComplaintGeneral; For the 1st combo box I have: Private Sub cboComplaintGeneral_AfterUpdate() Me!cboComplaintSpecific.Requery End Sub Table tblComplaintGeneral has two fields: ComplaintGeneralCode (autonumber), ComplaintGeneralDesc (text) Table tblComplaintSpecific has 3 fields: ComplaintSpecificCode (autonumber), ComplaintGeneralCode (long integer), ComplaintSpecificDesc (text) In addition, when I try to close the form I get a parameter window asking for a value for Forms!SF_Complaints_New!cboComplaintGeneral Any help is greatly appreciated. Ed Edward P. Tesiny New York State OASAS Evaluation and Program Monitoring 1450 Western Ave. Albany, New York 12203-3526 Phone: (518) 485-7189 Fax: (518) 485-5769 EdTesiny at oasas.state.ny.us - 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. _______________________________________________ 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 _______________________________________________ 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.