TextChanged for dynamically created control?

[Rob Meade]

Hi all,

I have a form where the controls for the page are created dynamically from a
database, in this case a series of text boxes and a drop down menu.

One of these boxes now has to be able to perform magic....

When a user has typed something into the box and moves away from it - ie
tabs/mouse clicks into another box I need the code to take the value, run
off to a database table, do a quick lookup and then return the result into
the text box (its likely a user might enter a consulants abbreviated code
for example - RDM - which would return Rob Meade etc etc)..

I was thinking that the textchanged method might help here - but I'm not
sure - as how would I set the 'handles' part of the code being that the
control hasn't been created yet!?

The names/id's of the controls are stored in the database too - so its not
until that page has been built that (and I'm assuming here) I would be able
to add a function that used its name/id?

Any info on this would be appreciated.

Regards

Rob