Usng a macro to hide/unhide subform

[shannaj via AccessMonster.com]

I have a database that tracks repairs of units that come to our facility. I
have a form that I use to enter work order details (S/N, Date fixed, Warranty
Status, notes). What I am trying to do is when they get to the "Warranty
Status" and choose "ABS" Which in our terms means a Return, I would like a
subform to appear to gather more descriptive details. I just do not need the
subform to appear if anything else is selected. I am trying to use an
example where you can use a toggle button with a macro to make subforms
appear and disappear and just alter the conditions. But I cannot figure out
how to get the conditions to work when the "ABS" field is selected. Anyone
got any ideas?

 

[Steve Schapel]

Shannaj,

I imagine you would have a SetValue action in your macro:
Item: [NameOfYourSubform].[Visible]
Expression: Yes

.... and the Condition would be like this:
[Warranty Status]="ABS"

I suppose this macro would be assigned on the After Update event
property of the Warranty Status control on your form.