Hello, I have a form that includes a text box (unbound) and a sub-form. I want to disable my subform when it's over at 9am. And the user can not enter data. Thank you if anyone can help
Sent from my SM-J701F using Tapatalk
Hello, I have a form that includes a text box (unbound) and a sub-form. I want to disable my subform when it's over at 9am. And the user can not enter data. Thank you if anyone can help
Sent from my SM-J701F using Tapatalk
You could adapt this:
http://www.baldyweb.com/ConditionalVisibility.htm
in the timer event of the form. Your test would look like:
If Time() > #9:00:00 am# Then
You'd set the AllowAdditions property of the subform (edits and deletes too if desired). Or just disable the subform control.
Many thanks for using the phrase. befor I did not use the # sign, so I did not get the result, but thanks for the time you gave me.You could adapt this:
http://www.baldyweb.com/ConditionalVisibility.htm
in the timer event of the form. Your test would look like:
If Time() > #9:00:00 am# Then
You'd set the AllowAdditions property of the subform (edits and deletes too if desired). Or just disable the subform control.
Sent from my SM-J701F using Tapatalk
No problem. I take it you got it working?