Dropdown list drops in the wrong place

[parishpete]

Default values do *not* Dirty a record so setting it would not cause the problem you are describing. You are aware that *all* Dirty records are always saved by simply trying to leave the record in any fashion, right?

Yes. I know what's happening here; Two fields out of the three have a value input by the button and trying to exit without completing the record, albeit a record I don't want, throws the error up.

I'll take a good look at how best to redesign it for my purpose.

Thank you so much for your assistance

best wishes

Pete

[RuralGuy]

I really think you could avail yourself of this event driven software to make things more automatic.

[parishpete]

I really think you could avail yourself of this event driven software to make things more automatic.

RG

I take your point, I'll take a good look at how this DB could be done better, currently it's useable and input is now a quicker process than it was.

Many thanks for your help

Regards

Pete

[RuralGuy]

As to your issue in post #26, you do know that hitting the Escape key twice will undo any changes to the current record, right?

[parishpete]

As to your issue in post #26, you do know that hitting the Escape key twice will undo any changes to the current record, right?

Ouch!! I'd completely forgotten that. Must be gettin' old

Many thanks

Pete

[RuralGuy]

And as I've said before, if you can find a way to use the DefaultValue instead of the Value then you will not Dirty the record and cause the error you are seeing.