HI All,

I have an excel spreadsheet that is used as a tool to
enter data into a heavily administered database.

I have a user form that is built from the table within
access that the data is eventually transferred to. How
ever:

The fields in this table are subject to change so the
table builds based on what is in the table and the text
boxes are labeled accordingly.

I have done this and the code/form works fine.

Now i need to have a macro called when the user enters one
of these textboxes. For example, the code will create a
text box and call it the same as the field in the access
table where the data will eventually go, ie.
txtDate_of_Birth, i need to work out how to put the
txt_Date_of_Birth_Enter() code in, when the name of the
text box may change.

Can this be done.

Nath