>i have 2 table with the same structure. In my form i set the controlsource of my textbox to fieldname. my textbox is empty unless
>i specify the tablename like mytable.fieldname. how could i use the controlsource property for my 2 tables.
>
>thanks

May be I don't understand the question, but it is the normal practice to include alias name with field name, as you do. If you want to use the same textbox with two different tables with the same structure, just reset
Textbox.ControlSource = myNextAlias.MyField
somewhere in code when necessary.

HTH,
Nick