Reset text box value on new record
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
I'm now using the mousewhell event to reset it, which works ok, but not if the record selectors are used.