I'm looking to get some sort of conditional rule in there which reads the users points value and if they have less than 150 runs another Macro that tells then they cannot continue (and then stops the current macro).
Can anyone offer advice getting the conditional rule in there? I could use code but for this scenario it has to be a macro.
The pseudocode I want to follow is:
If button1 is clicked then
if guest_points is less than 150 then
continue running the subtraction and field update to remove 150 points.
What you'd like to do can be easily accomplished with VB. On the OnClick event of the button, insert some code like:
if [Forms]![frm_qry_choose_gift]![Point Balance] > 150 then
[Forms]![frm_qry_choose_gift]![Point Balance] = [Forms]![frm_qry_choose_gift]![Point Balance] - 150
msgbox "Value is too low.",vbCritical, "Invalid"