Is it possible to use the same subform on more than one master form? I have 2 master forms for employees to enter data input. Each form has a field on it for them to input their employee #. I have a subform that when then input their #(QEmp ID#) on the master form, their name appears on the subform. The subform is based on a simple query with two fields Employee Name, and QEmp ID#. The master field is QEmp ID# and the child field on the subform is QEmp ID#.
My problem is that this works fine on one form but when I tried to apply the same strategy to another form the employee name doesn't show up upon entry of their #. However if you close the form and then reopen it the employee name is there. I've tried a few tricks like a macro for requery... except it wants to requery the entire form which unfortunately does not work because the form is based upon a query and the query asks for a File # before the form is opened. So when I requery during the initial data input I get asked for the file number again and for some reason get sent into a never ending loop.
Any ideas would be appreciated.
Tp
My problem is that this works fine on one form but when I tried to apply the same strategy to another form the employee name doesn't show up upon entry of their #. However if you close the form and then reopen it the employee name is there. I've tried a few tricks like a macro for requery... except it wants to requery the entire form which unfortunately does not work because the form is based upon a query and the query asks for a File # before the form is opened. So when I requery during the initial data input I get asked for the file number again and for some reason get sent into a never ending loop.
Any ideas would be appreciated.
Tp
