Reload list values of combo box

[tamus121]

I have a combo box (with value list) on a subform which limits users entering data following an inspection to a list of 8 different types. When a selection is made, the value is removed from the combo box list so that it can't be entered twice at any one inspection. When the user moves on to a new inspection I need the list to be updated with all the values again. This will happen if the form is reloaded but I thought it should be simpler to do and have tried cmbbox1.requery from a control button on the subform but to no avail. Any suggestions please.
tamus

 

[TheAceMan1]

How are ya tamus121 . . .

If I understand you correctly you want to remove the selected item in the list and put it back when an alternate selection is made (again removing the selected item from the list). Is this correct?

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[tamus121]

The user may select one or more values from the list and supply extra information in a notes field. When they move unto a new client all the list is needed again in the combo box. I thought some method of requery would do this but from reading and experimenting I beleive that this is not possible unless I reload the form that contains the combo box. As there is only 8 values in the list I found I could reset the combo box rowsource when the user moves to the next client. So I have got it working - just not the way I was trying at the beginning.
tamus