Set Control Property for Continuous form based on value in that record

[dmenger]

Hi all,
I should be able to do this but can't find the solution.

Using Access 2013

I have a continuous subform based that is has a parent child link to the main form.
In the sub form I want to put a button that only shows based on a value for that record in the sub form.
Right now I can only get this to recognize the first record, but I need this to be dynamic for each record.

[burrina]

I suspect you are placing the command button on each record. I would place it on the form header or form footer and then use the OnGotFocusEvent to fire your code.

HTH

[ssanfu]

I agree with burrina. The button should be placed in the sub form header. But I would use the subform current event. Each time you change records in the sub form, the On Current event fires.

I don't like having objects appear and disappear unless absolutely necessary/required, so I would use the Enabled property of the button.