[AccessD] Help with Combo Box

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.




More information about the AccessD mailing list