something not adding up here
Form control #1 contains unique text (selectable options from a drop-down combo box).
Blank by default.
If it is blank when the form opens, it's probably not bound - or if it is, its list source (combo rowsource property) just happens to have a null or empty string (zls) which just happens to be the first in the sort order. Are you sure the combo has a *controlsource property? If not, I can't use the OldValue property and will have to do something a bit more complicated.
If you're using the combo to filter records, it is normally not bound to a field (it can still have a rowsource though, which is what populates the drop down list). Binding a search combo means you will change the value stored in the record when you think you're just playing around and filtering records.
* = corrected
EDIT
From something to something in #1, don't do anything in #2.
Just realized that "do nothing" could mean leave a value if it's there. It could also mean nothing should be in #2. So,
if combo value is A and A is selected again, leave #2 as is regardless of whether it contains the date or not, and
if combo value is A and B is chosen, same - leave #2 as is regardless.
Or something else?
There's more to this than first meets the eye.
Last edited by Micron; 10-21-2021 at 03:58 PM.
Reason: correction
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.