Set field property after moving to another record 1

[annie52]

When I open a subform, I set the visible property of a text field and label to true/false based on whether the text field is empty or null. When I move to the next record on that subform, the text field and label visible properties stay as they were from the previous record.

I can't figure out what event (the, "I just moved to another record" event) I need to code.

 

[dhookom]

Try the On Current event of the form.

Duane
Hook'D on Access
MS Access MVP

 

[annie52]

That's the one! Thanks Duane.