Access - Conditional Macros
I've got a Macro assigned to a button on a form which is a query output. When the user clicks on the button it reads a value from a field and subtracts 150. It puts the new value back into that field.
I have done this with a Macro
The Macro looks like this:
GoToControl Points Balance
SetValue [Forms]![frm_qry_choose_gift]![Point Balance], [Forms]![frm_qry_choose_gift]![Point Balance]-150
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 (or stops this Macro) that tells them they cannot continue.
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.
Any help is appreciated,