[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.