Refreshing???

[dar]

I have a parent/child form/subform linked by Med Number. The sub form then
has several records. On sub form is floor locations. If patient moves I
need to list the new floor location. With that, the therapist may change.
When I use the Control F9 to refresh, the subform goes back to the first
record instead of staying in the current record. How do I keep it in the
current record?

 

[Wayne-I-M]

Set the
me.refresh
action on AfterUpdate of the subform field not in the main form

 

[dar]

Thank you. That worked.

Set the
me.refresh
action on AfterUpdate of the subform field not in the main form


--
Wayne
Manchester, England.
Not an expert.
Enjoy whatever it is you do.

 

[Wayne-I-M]

NO worries - have fun


--
Wayne
Manchester, England.
Not an expert.
Enjoy whatever it is you do.