Hi there:
I have form Form1 and subform in it Form2, these both forms are used to populate two different tables. Both these tables contain similar text fields(such that CompanyName, address,etc). During data entry I want to display the information that has been entered in Form 1 (for text fields CompanyName and Address), in my subform Form2 having same fields, without reentering them again(so that it displays whatever entered in the text fields in form1). I tried DLookUP() but its not working for some reason. Does anyone know any alternative to this?
I'll appreciate your help.
-JagGa
I have form Form1 and subform in it Form2, these both forms are used to populate two different tables. Both these tables contain similar text fields(such that CompanyName, address,etc). During data entry I want to display the information that has been entered in Form 1 (for text fields CompanyName and Address), in my subform Form2 having same fields, without reentering them again(so that it displays whatever entered in the text fields in form1). I tried DLookUP() but its not working for some reason. Does anyone know any alternative to this?
I'll appreciate your help.
-JagGa