F
faapa via AccessMonster.com
Hey all
i was wondering if someone can help me tweck this code..i'm trying to make
the user enter infomation in a textbox (v_actual_source) if they click a
button (btnAchieved). I don't want the user to exit it the form without
entering info in that textbox as i have another button they can press once
they have entered info in v_actual_soruce that wipes out the info (resets it)
So far, add code in the btnAchieve_Clikc()
If IsNull(Me.V_ACTUAL_SOURCE) Then
Cancel = True
MsgBox "Please Enter Source Name", vbOKOnly + vbCritical, "Data Requirement
Error"
End If
itonly pops up a msg reminding the user that they must complete the
v_actual_source textbox but still allows the user to exit the form without
entering info in that textbox.
Does anyone know what the extra bit of code is to stop the user from exiting
the page unless the extra info is added??
i was wondering if someone can help me tweck this code..i'm trying to make
the user enter infomation in a textbox (v_actual_source) if they click a
button (btnAchieved). I don't want the user to exit it the form without
entering info in that textbox as i have another button they can press once
they have entered info in v_actual_soruce that wipes out the info (resets it)
So far, add code in the btnAchieve_Clikc()
If IsNull(Me.V_ACTUAL_SOURCE) Then
Cancel = True
MsgBox "Please Enter Source Name", vbOKOnly + vbCritical, "Data Requirement
Error"
End If
itonly pops up a msg reminding the user that they must complete the
v_actual_source textbox but still allows the user to exit the form without
entering info in that textbox.
Does anyone know what the extra bit of code is to stop the user from exiting
the page unless the extra info is added??