SetValue Macro (Set.Visible)

[brianborn]

I have a form that has a subform that is NOT visible. I would like for the subform to be visible when the carrier is set to UPS Small Package, but I cannot get it to work. Attached is a screenshot of the macro and form design. There is also a link to the screenshot just in case the images doesn't appear. I have tried this macro in several events, but without any success.

Can someone help me with a solution?

http://screencast.com/t/n8rrb7z5lE

If [tbl_ShippingLog]![FreightCarrier]="UPS Small Package"
Then Item = SetValue [Forms]![frm_ShippingLog - Matt Marshall]![OptionsUPSform1].[Visible]
Expression = Yes
End If

 

[pbaldy]

I don't use macros, but the VBA is fairly simple:

http://www.baldyweb.com/ConditionalVisibility.htm

 

[brianborn]

Thanks Paul. For a temporary fix, I can do this. Currently I'm working toward converting my database to be web ready for Access Services and from my understanding is that VBA is not compatible.

 

[pbaldy]

Your understanding is correct. I don't have Access right now, but I think the action is now SetProperty. If you can post the web db I'll play with it.

 

[brianborn]

I'm still months away from converting everything so it will be web ready. If I didn't have a job and also going to school, I would have a lot more time to work on the DB. I learn so much more building my own DB in Access than they teach in school.

 

[brianborn]

I don't use macros, but the VBA is fairly simple:

http://www.baldyweb.com/ConditionalVisibility.htm

Having the database working the way I want is more important than making sure it will work on the web. At least at this point it is.

I followed the directions on the link you shared and it works great! Thank you!

 

[pbaldy]

Excellent! Glad it helped.