Re: mutiple Combobox 's problem

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 08/26/04 

Date: Wed, 25 Aug 2004 23:43:10 -0600

On Wed, 25 Aug 2004 17:31:08 -0700, "Sammy"
<anonymous@discussions.microsoft.com> wrote:

>You are right each record would have an equal amount of
>combo boxes. However, each time you open the form it have
>a different depending on the variable you select to open
>the form. Let me consider just one record and can
>recreate for the other. What I am thinking is create a
>hidden textbox. Some how count the number of combo boxes
>are on the form. For each combo box enabled and is not
>null have it add a number inside the text box. If the
>number equals the number of combo boxes then have it do
>something if not then have it do something else. Would
>this be a better scenario? If so how do I do the loop?

I'm still not understanding the situation.

What determines whether a combo box is enabled (visible??) or not?
What are the Control Source properties of these combos? What data
exists in the table? What is the significance of this variable, and
how is it specified?

I'll be out of town tomorrow - if nobody else jumps in, please repost
so the other MVP's won't take this as an answered thread... because
I'm still confused!

                  John W. Vinson[MVP]
             (no longer chatting for now)

Relevant Pages

  • Re: 3 Linked Combo Boxes
    ... what i need it for is to keep a record of software details on a computer - ... options in the third combo box depending on selection in the second... ... > boxes represent, and how you want the data input to work. ...
    (microsoft.public.access.forms)
  • search button to report based on multiple combo boxs ( combo criteria based upon queries )
    ... So I have this form that wants to read four combo boxes and then ... Now depending what you choose, I would like the program to search based ... Dim stDocName As String ... Dim strSQL As String ...
    (microsoft.public.access.forms)
  • Re: Dependent Combo Boxes - No Values
    ... "Michelle" wrote in message ... he/she should bother pulling down the combo box down arrow to see if there ... Depending on prior combo box pull downs, ... Since the form has about 15 combo boxes, ...
    (microsoft.public.access.formscoding)
  • Re: Userform options
    ... Thanks Bob. ... I need to make options appear depending ont he ... selction in the drop down box or tick box. ... text boxes in case there are lots of units, ...
    (microsoft.public.excel.programming)
  • Combo Box Scroll Bar
    ... I have Excel 2002 SP3 ... I created 2 combo boxes. ... depending what is chosen on the first combo box. ...
    (microsoft.public.excel.programming)