[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