remove a single item from a combobox

[AccessWillKill]

i have a combobox with brings up 4 values. The combobox rowsourcetype is table/query.

so for example say i have in this combo box values 1,2,3 and 4. I then have a pop up box saying 'is the record you want to create value 4?' If yes then type 4 successfully is slotted into the combobox, which is disabled to prevent any more editing. and a few extra fields appear on the form that need to be filled. However if it isn't, i want type 4 not to appear in the combo box for selection, which it does.

My efforts to remove it bring back the same thing over and over 'Need to change the rowsourcetype to 'value list' which isn't an option. is there a way to code the combobox so if 'no' is clicked in the pop up box then that value removes from the selection?

 

[gemma-the-husky]

you need to play with queries

you need to find a way of designing the query to include only the items you want

then, if you do something that should change the items returned by the combo's query -you just need to use

mycombo.requery, at the appropriate point

same technique you would use for cascading combos.

 

[AccessWillKill]

Cheers, i got it working in the end. just changed the way things will work. makes it more simplistic.

i now have another problem i shall post