how to set page.visible to false in open or load event

[Gerry Goldberg]

My form is based on a table of grant information. It has a page for the grant application (pgeApp) and a page for the Grant award (pgeAward). I would like to make the grant award page visible only when the application status (on pgeApp) is set to "Awarded". In the AfterUpdate event for the [Application status], I check to see if the status is "Awarded" and if it is, I set the visible property of pgeAward to true, and everything works fine. When the form opens however, I need to initialize this visibiliy for the pgeAward. I am using the same logic in the Open (or Load) event, but it doesn't work. The code I use is:

Me![pgeAward].Visible = Me![cboApplicationStatus].Column(1) = "Awarded"

Can you tell me what I'm doing wrong, or if there is a better way to do this.

Thanks,

Gerry Goldberg

[NeoPa]

I would expect the best place to put this code would be in the Form_Current() event procedure.

I would also recommend putting the assertion within parentheses :

Me![pgeAward].Visible = (Me![cboApplicationStatus].Column(1) = "Awarded")

[Gerry Goldberg]

Great! I followed your suggestion and it worked perfectly.

Thanks for your help.

Gerry Goldberg

[NeoPa]

No worries. A pleasure to help :)

Welcome to Bytes!