Usng a macro to hide/unhide subform

  • Thread starter Thread starter shannaj via AccessMonster.com
  • Start date Start date
S

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?
 
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.
 
Back
Top