Solved Form can no Longer be Updated Message (1 Viewer)

Number11

Member
Local time
Today, 11:58
Joined
Jan 29, 2020
Messages
607
Hi, So i am looking for a way to stop users updating the form if the information has been sent to the 3rd party, this is currently shown in a date field called "Sent to 3rd party" 00/00/00. If this field has a date i would like a message box to inform user that updates can be made via the database and for them to call the 3rd party possible?
 

Ranman256

Well-known member
Local time
Today, 07:58
Joined
Apr 9, 2015
Messages
4,339
If you mean update the data in the form,(not update the form design)
Have an invisible label with your message. 'Call 3rd party'

In the ON CURRENT event,decide what to do....

Me.locked = not isNull(txt3rdParty)
LblWarn3rdParty.visible = not isNull(txt3rdParty)
 

Number11

Member
Local time
Today, 11:58
Joined
Jan 29, 2020
Messages
607
If you mean update the data in the form,(not update the form design)
Have an invisible label with your message. 'Call 3rd party'

In the ON CURRENT event,decide what to do....

Me.locked = not isNull(txt3rdParty)
LblWarn3rdParty.visible = not isNull(txt3rdParty)

Getting Run time error 424 Object Required on your suggestion?
 

Number11

Member
Local time
Today, 11:58
Joined
Jan 29, 2020
Messages
607
Got it working using this methiod
Me.NameOfLabel.Visible = Not IsNull(Me.Completed])
 

zeroaccess

Active member
Local time
Today, 06:58
Joined
Jan 30, 2020
Messages
671
The method I use is to implement a Status field for the form, with New and Complete being your options. Once you click Complete, the status is changed, and you can do any locking/disabling based on that status.
 

Users who are viewing this thread

Top Bottom