Just wanted to thank everyone who helped with my last problem.
I am still working on different ways to lock my info up. Here is my question, Can you lock a field only when it has data and only when it has lost focus.
I have a cmbo box that i use to select a time then when i make the selection the focus is moved to a text box. Can I have the filled field (cmbo box) locked? Then when I am done the text box and move to the next field can I then have that field locked?
now the trick is when I pull in the next record I want the empty fields to be UN locked so I can use them.
I hope this makes sense.
I am new at this and I fear I am in a bit over my head. Any help is greatly appreciated.
You basically need to have the Oncurrent Event (triggered every time you move to another record) to check and release the combobox from 'locked' status and when combobox loses focus or Onclick event is triggered, you change the locked status for the combo box. There are so many events which you can use/combine to make the form behave the way you want.