unbound control old value

[JEM]

I have an unbound form (Access 2003 ADP/SQL Server 2000) that each
time a value is selected in one of the controls, it is written to a
table. This works fine. But, if the user changes the value they
selected, I need to be able to delete the previous value they had
chosen and then add the new one instead. I have realized through my
trial and error that .OldValue does not work for unbound form/
controls. Any other ideas on how i can handle this? The form is a
sort of "query" creator and it is writing values to a table of which
criteria they have selected so they can review before they push the
button to create the query.

Thanks for any advice!

Jenn

 

[alex]

I have an unbound form (Access 2003 ADP/SQL Server 2000) that each
time a value is selected in one of the controls, it is written to a
table. This works fine. But, if the user changes the value they
selected, I need to be able to delete the previous value they had
chosen and then add the new one instead. I have realized through
mysfwrtsgatwaghaywhajwuaiak\mznafgggggggggggvdvdvssb x
bvsgxgxsbscxxbdsshdhxdhdhsxx
trial and error that .OldValue does not work for unbound form/
controls. Any other ideas on how i can handle this? The form is
aazzbzbgAAHHBSSBSDSXNXCDCdsxjejsDAJSZJMSJZZZSM SEND
sort of "query" creator and it is writing values to a table of which
criteria they have selected so they can review before they push the
button to create the query.

Thanks for any advice!

Jenn