crazy_ivan_1
New member
- Local time
- Today, 17:43
- Joined
- Jun 7, 2020
- Messages
- 23
Hi,
I'm trying to create a rating system of sorts.
I have 5 fields with a combo lookup. Each lookup has values 1-5
I am trying to get the comboboxes to update based on the values of the other fields.
E.g.
Cmb1 has number 4 selected
So cmb2 to cmb5 will only show numbers 1,2,3 and 5
Then cmb2 has number 2 selected
So cmb 3 to cmb5 will only shows numbers 1,3,5
And so on.
I'm guessing that I need an after update of cmb1 I would need a requery of the values to eliminate the selected value, but I can't figure out how to do it.
Any suggestions or help would be most appreciated.
Thanks
I'm trying to create a rating system of sorts.
I have 5 fields with a combo lookup. Each lookup has values 1-5
I am trying to get the comboboxes to update based on the values of the other fields.
E.g.
Cmb1 has number 4 selected
So cmb2 to cmb5 will only show numbers 1,2,3 and 5
Then cmb2 has number 2 selected
So cmb 3 to cmb5 will only shows numbers 1,3,5
And so on.
I'm guessing that I need an after update of cmb1 I would need a requery of the values to eliminate the selected value, but I can't figure out how to do it.
Any suggestions or help would be most appreciated.
Thanks