Refresh Form after data change

[pat_nospam]

Hi, I'd like to be able to refresh a form after someone clicks on a checkbox in an option group to change some data. Essentially, I have a picture that correlates to the checkboxes. The picture updates fine, but currently they wont see "live" updates, only after they navigate away and back do they see the picture change.

Any ideas?

 

[dcx693]

Try these various methods, in order, until you find the one that works:
Me.Repaint
Me.Refresh
Me.Requery

 

[dcx693]

Also, be sure to verify that you are referring to the control names and not the field names on your form. I once had an issue where I wrote: Me.StartDate=Date(). Instead, I really meant: Me.txtStartDate=Date(). Of course, the controlsource for the txtStartDate field was the StartDate field. And it would only update if I navigated away and went back to the record. Took me a while to find that mistake.

 

[pat_nospam]

Worked like a charm, thanks for the assist!