Hi everyone,
I have a form named "Main_frm" and the main info comes from a tabled named "Root_tbl" with the field named "root"
The form has into a field named Roottxt ([Root_tbl]![root])
I want to add a second field named Root2txt and I want the info comes from a second tabled "Root2_tbl" with a field named "root2"
(both tables have just one record, I don't really need to be recording more info further but I don't want to create a second form)
I tried to put into the control source of Root2txt the next statement
=[Root2_tbl]![root2] but it shows #Name once open the form
What Do I have to correct?