DateIssued.Locked =

[buzzbait9]

Hello,

Me.DateIssued.Locked = Not IsNull(DateIssued)

I used this code to lock a date box in my subform. the item was already issued in the table. If it wasn't issued, it would have kept the field Unlocked.

Now when I change the main form to a different record that has no issue date, I can't seem to unlock the textbox so I can add the Issue date of the record.

Can I have a Hint on this one?

Thanks

 

[pbaldy]

Add that code to the current event of the form.

 

[buzzbait9]

Awesome! Thank you

 

[pbaldy]

Happy to help!