I have a report of Employee’s jobs, named EmployeeReport. I would like to open a form named “Form1” when I click on an EmployeeID on the EmployeeReport. Form1 is not set on a table or a query. This form has some unbound controls. One of the controls is named “Employees”.
So far, I know I should set a macro command, onclick “EmployeeID”, to openform and formname: Form1, view: normal. This command opens Form1. But the unbound control “Employees” is left blank.
How can I make the macro so that when I click on the “EmployeeID” of the EmployeeReport , Form1 is opened, and the “EmployeeID” is shown in the “Employees” control of Form1?
So far, I know I should set a macro command, onclick “EmployeeID”, to openform and formname: Form1, view: normal. This command opens Form1. But the unbound control “Employees” is left blank.
How can I make the macro so that when I click on the “EmployeeID” of the EmployeeReport , Form1 is opened, and the “EmployeeID” is shown in the “Employees” control of Form1?