Nadya,

If I do it your way, would the ControlSource in each textbox on the form be thisform.oTable.fieldname1, thisform.oTable.fieldname2, etc.?

My guess is that the guy I work with won't let me do it your way and would rather have me do PUBLIC oTable in the form init. I think I passed the form property idea by him last week and he made a face.

The only disadvantage to doing it your way that I can is that the names in the ControlSource are longer when I do it your way. oTable.fieldname1 vs. thisform.oTable.fieldname1. That is provided that I am stating the ControlSources correctly.

How can something so simple be so difficult at first? I can blame the manuals and books for not covering this subject adequately. I use my reference books all the time. The UT usually wins out over the reference books though because you get a simpler more direct answer that is usually used in the real world.

Thanks for the advice.