With help from Maurice, I now have two fields and associated labels that become visible/invisible dependent on the selection/status of a checkbox.  The visibility is controlled in the AfterUpdate property of the check box.  See previous "field visibility" post.

What I am now looking to do is have the visibility of those fields change as I navigate between records.  So if the checkbox is unchecked for a particular record, then the fields are not visible when this record is displayed in my form.

Can someone tell me in which event this test should be applied?

I'm thinking this should be a form event, but I don't see a change record event as such.

Thanks

Phil

Hi Phil,

You can accomplish this by using the 'on current' event of the form. That way when you navigate to another record you can trigger an event. Be aware though that this is a costly event because it will fire every time you go to another record.

You can use the value of the checkbox as your trigger. Something like if me.checkbox=0 then me.label.visible=true or false.

Let us know if that helps

Maurice

Brilliant thanks Maurice

That's my principle form sorted

Phil