Hi All

I have an unbound text box that I fill with an on click event,with data from the data base, is there a way to fill this each time I change record, I can't seem to get it to work.

What I have is a course and people on the course, what the code does is do a trip to the database, get all the email addresses of the people on the course and concatenates them. (don't ask why - partner wants it), but I can only get it to work with the on click of a button, not automatically each time i move record.

Hope yo ucan understand

Andy Green

UPDATE

I'm now using the mousewhell event to reset it, which works ok, but not if the record selectors are used.

Andy,

Have you tried the on current event? Put the code that you have behind the button click, and put it on the on current event.

Kevin

dartcoach

Thank you

Works a treat, think I tried nearly every other one.

Andy

Andy,

Glad I could help.

Kevin

dartcoach