How can I get a subdatasheet to update immediately?

G

Guest

I have a subdatasheet(controlled by a query) I am using in a form. When I
type in a person name(already in the database) into the form I want the
subdatasheet to automatically show the information on the person as soon as I
tab to the next field in the form. Currently it shows the subdatasheet only
after I go to the next record then come back. I want it to update right away.
I know it can be done but I don't know how. Any suggestions? Thanks
 
G

German Saer

in the event afterupdate of the person's name type me.form.refresh.

hope it helps


--
___________
Thanks,

German Saer
Orlando, FL
 
G

Guest

It worked! Thanks a million!

German Saer said:
in the event afterupdate of the person's name type me.form.refresh.

hope it helps


--
___________
Thanks,

German Saer
Orlando, FL
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subdatasheet Help 3
Check box count from subdatasheet 2
Printing records in a subdatasheet 3
problem with delays on form 5
Append Query Include Subdatasheet 2
Subdatasheet problem 1
can't add a subdatasheet to a linked table 1
Accidentally removed subdatasheet 3

Top