Seeking guidance or possibly a miracle regarding bound comboboxes

[Kjestice]

I've been reading through the forms section and haven't run across an answer to my question. From what I've read, I've come to the conclusion that to keep a value selected in a combo box from populating the data in my table is to make it unbound but I've done a ton of work on a new forms for my group and I really don't want to duplicate what I've already done. This was actually the last issue that I ran into. Is there really not a way to keep a bound combo box from writing to my underlying table or is there any type of work around?
The easiest form that I've created and will use as an example is one where a search is performed using 3 cascading combo boxes and 2 of the resulting fields need to be updated (a code value and possible notations). The first record that the form pulls gets updated with erroneous data for the combo boxes.



This one is a split form pulling data from only 1 table. I didn't think that I needed to post any VBA code but can if anyone needs it.

Thanks in advance.

[RuralGuy]

I'm sorry but Bound Controls save the selected data to the bound field. Why does it have to be bound?

[Micron]

Agree with RG. What's the point of binding it if you don't want alternate choices to update the table field? You'd have to provide more info about the process and/or design to have us suggest an alternate method, but I suspect that you've boxed yourself into a space where you don't want to backtrack and undo a bunch of work. To answer the question about a work around, what comes to mind is a temp table that you don't care what happens to the records because you'll flush it when you're done. But that brings me to RG's question...