Combobox behaviour

[Dennis Snelgrove]

I've got a subform set for Continuous mode witha combobox on it. The
subform is only supposed to allow the user to enter one record against
each value in the combobox's drop down list. I prefer to "help" the
user out when it's appropriate; in this case by having the combobox
requery in the "Form_Current" event to eliminate entries already having
a record against them. Of course, doing this affects the recordset for
all the records in the subform and causes those already entered to lose
their values. Any suggestions as to how to get around this behaviour,
aside from "Don't do this"

 

[Rob Oldfield]

Can I use "This is a really bad idea" instead?

I asked a very similar question - about list boxes instead of combos, but
it's the same issue - to this years ago (just Googled it, it's called
"Tricky form layout"....aaahh, the memories) and didn't really come up with
anything wildly good.

Bas Cost Budde had a go and came up with this

http://www.heuveltop.nl/BasCB/msac/mulenu.html

but it's not very elegant and lots of work. I'd tend to go with a button by
the side of a text box which opens up another form just including the combo
with the correct record source set.

 

[Rob Oldfield]

There again, maybe I should engage my brain before coming up with an answer.
I would have thought that with a combo it should work because you don't
actually need to display all the choices simultaneously. So I can't see why
existing values should be disappearing. What code are you using?