Processing Forms (1 Viewer)

[Acme]

Hi All,

I am sure I am not the first to try to do this. I have a form that posts to a database with calculations. Thing is, I want to be able to have the form values freeze based on the status, which is a combo box on said form. Issue is, when I use what I learned (I learned to set all controls on form to allow add/edit/delete = false, it also sets the status field to false. I am unable to find code that would turn down the controls, and then at the end, flip the status control back on to allow the status to change again. I can prolly think of a way around it, but wanted to know what you think is best.

Thanks,
Ac

 

[James Dudden]

You could switch edits back on when the user clicks in the status box and then turn them on or off again depending on the status they choose. This could be done via the Got Focus event.