Macro for a condition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I would like to know how to create a macro with the following condition. If
tick box is true (ticked) then a lookup column appears. If tick box is not
ticked my lookup column does not appear on screen.

Can anyone help?

Cheers
 
Lost,

Assuming you are talking about a continuous view form, you can use a
SetValue action in a macro which you would assign on the After Update
event property of the tick box, Set up your macro like this...
Condition: [NameOfTickBox]=0
Action: SetValue
Item: [NameOfLookupControl].[Visible]
Expression: No
Condition: [NameOfTickBox]=-1
Action: SetValue
Item: [NameOfLookupControl].[Visible]
Expression: Yes
 
Back
Top