I have a form with several fields on it from the Employee table, one of which is EmployeeNumber. I am trying to create a button via the Command Button Wizard. This button will open another form (Training) with several fields, one of which is EmployeeNumber, on it from the Training table. Both tables have EmployeeNumber field and are linked together via this field. In the wizard I select "Open the form and find specific data to display". I do this because I want to display the employee training info for the employee that is displayed on the first form. I click on next and your supposed to select the matching fields from the two forms. The frmEmployees is showing no fields listed and the frmTraining is showing all the fields on that form as it should.
I cannot figure out why the fields are not showing up in the Command Button Wizard for the frmEmployees.
If you can let me know why and how to fix this, I would greatly appreciate it.
Thanks