Setting Rowsource property using VBA

[respinosa]

I've been trying to set the Rowsource property for a combo box using this code:

Private Sub Sales_Width_Tolerance_Click()
Me.Sales_Width_Tolerance.RowSourceType = "Value List"
Me.Sales_Width_Tolerance.RowSource = "+/- 1 mm"
End Sub

It will not work. Is there something that needs to be selected in the VBA environment under Tools>>>References...?

 

[xenou]

It's basically working for me but I cannot understand why you would do this. You want to change the rowsource when the combobox is clicked? Plus you won't see anything change visibly even if it works.

It seems that the event fires when the user makes a combobox selection, not just any old click. Not sure though - would need some tests (or check some documentation on the event).

Note: you do not need anything special checked in references for this.

 

[respinosa]

I was testing the code to see if it would work before I invested a WHOLE lot of time writing what I really wanted to do. I would actually have several more choices in the list based on a value that the end user selects in another combo box. Should I use a different event in this combo box? I used the Got Focus event and it didn't work either. Alternatively, should I use the After Update event of the other combo box to update the row source of this combo box? Thanks!

 

[xenou]

Yes, the after update event of the other combobox may work better, I think.

 

[respinosa]

Well, I tried the After Update event of the other combo box and it still doesn't work. Do you know of any other resources I can check?

 

[xenou]

For cascading combo boxes you can google "msaccess cascading comboboxes" or "msaccess dependent comboboxes"

I have used this strategy:
Access Tips: Cascading Lists for Access Forms

 

[respinosa]

Thanks, I'll give it a shot!