it is possible to not refer to already created query but to set up combobox values from 1 to 100 inside combobox source row property?
Can anybody help?
it is possible to not refer to already created query but to set up combobox values from 1 to 100 inside combobox source row property?
Can anybody help?
Well if he indeed wants a selector for the numbers 1-100, the most convenient method imho would be to have a textbox instead of a combo.
Then set the Validation Rule to : <=100 and then set the Validation Text to something in the lines of: XXX can not be a number higher than 100.
(just for fun)
I have thought of maybe the most inconvenient way to handle this!
It would be a button + textbox combination, let's say we name the textbox "txtBox" and the button "btn1"
You could then go to the button's Click event and set it to this:
Code:
Private Sub btn1_Click()
txtBox.Value = Int((100 - 1 + 1) * Rnd + 1)
End Sub
Which results in the most frustrating user experience i can imagine!