0

I have 4 cascading combo boxes linked to each other and they do exactly what I want them to do. However, I would like to take a shortcut with them and have them auto populate if they only have one list count.

I've already searched this and got a pretty good explanation from this link: Access cascading combobox autofill When left with one option

However, I am making a webform and I do not have access to VBA. How can I translate the VBA into a macro?

I imagine it's some type of "IF" option, like if the list count in combobox2 = 1, then do something. I just don't know what that something would be.

June7
  • 19,874
  • 8
  • 24
  • 34
howradisit
  • 43
  • 3
  • 12
  • Possibly the 'something' would be SetValue. Click "Show All Actions" on the ribbon. – June7 Oct 25 '18 at 21:35
  • And considering it's a cascading form, what would I set the value to? – howradisit Oct 25 '18 at 22:19
  • I don't use macros so did some exploring. Appears combobox properties Column and ItemData and ListCount are not available. This simply might not be possible with macro. Users will just have to select item even if there is only one. – June7 Oct 26 '18 at 02:55

0 Answers0