Drop Down list

[DavidCantor]

How do I reference the selection made on a drop down control?

I have a drop down control with values AA,AH,AP and more
If AA is selectedthen I want access to show more controls for data entry relevant to AA
ANd if AH is selected then I want it to show controls relevant to AH

etc,

the drop down source is AA; AH etc and not a query
Thanks

 

[rodmc]

How do I reference the selection made on a drop down control?

I have a drop down control with values AA,AH,AP and more
If AA is selectedthen I want access to show more controls for data entry relevant to AA
ANd if AH is selected then I want it to show controls relevant to AH

etc,

the drop down source is AA; AH etc and not a query
Thanks

Im not sure I follow you, do you mean you want to use the combo (drop down box) as a filter?

How did you create your drop down? (refer to it as a combo box, as that is the name its given in access)

 

[DavidCantor]

The Combo box is a filter only showing the controls on the form that are relevant to the selection.

 

[DavidCantor]

I just need the correct syntax to reference the selected option on a combo box.

something like:

me.comboname.selected.value or

me.comboname.value= "aa"

 

[AccessMSSQL]

David:
It's not really like .NET or VB. You don't really need to reference the selected property or anything. It's simply this:

if me.combo = "AA" then
   'hide or show your controls
end if

 

[pr2-eugin]

This should be sufficient to access the control..

Me.comboname = "aa"

 

[DavidCantor]

thank you so much!

 

[DavidCantor]

how do I allow multiple selections from a combo box?

 

[AccessMSSQL]

You can't. Use a listbox instead.

 

[AccessMSSQL]

You need to reference the listbox items as follows:


For i = 0 To Me.YourListBox.ListCount - 1
if Me.YourListBox.Selected(i) = True then
'do something
end if
Next i

 

[pr2-eugin]

Not sure if they do multi select combo box anymore.. .. best to use ListBox.. looks neat too..

 

[DavidCantor]

thanks,
how do I reference the values that are selected if there is more than one value?

 

[pr2-eugin]

Look at Post #10 by AccessMSSQL..

 

[DavidCantor]

ok great,

Now I want Access to display only the controls that are relevant to the values selected by setting their visble property to true


can I just enter

dim varFieldname as variant
 
For i = 0 To Me.ListSymbolSelect.ListCount - 1
 
If Me.ListSymbolSelect.Selected(i) = True Then
 
varFieldName = i
 
 Me.varFieldName.Visible = True
    Me.ListSymbolSelect.B_varFieldName_Location.Visible = True
    End If
Next i

will this iterate through the selected values and make the Location field visible for all the items selected?

 

[AccessMSSQL]

What's varfieldname? This won't work. You can't set visible property of a variable.
Also, i is not the value of your listbox. that is the number.

To get the value of your listbox you would need to do this:

varFieldName = Me.[ListSymbolSelect].ItemData(Item)
    me.controls(varFieldName).visible = true

if that doesn't work, use this:

dim ctl as variant
for each ctl in me.controls
   if ctl.name = varFieldName then
      ctl.visible = false
   end if
next

You need to reference the actual names of the controls that are on the form.

 

[DavidCantor]

This is what I have and it is not working for me

Private Sub ListSymbolSelect_Click()
Dim varFieldName As Variant
    
For i = 0 To Me.ListSymbolSelect.ListCount - 1
If Me.ListSymbolSelect.Selected(i) = True Then
varFieldName = i
'do something
End If
 Next i
Dim ctl As Variant
For Each ctl In Me.Controls
   If ctl.Name = varFieldName Then
      ctl.Visible = False
   End If
Next
   
End Sub