>>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

Thanks Nick