Is there a way to open another form using info from an already existing one?
For example, I have a form which lists companies and it has an employee subform (which lists a query output) on the same form. I'd like to program it so that when I click on an employee row (in the subform), a separate form pops open to display employee specific information (from the row that I clicked) and cycle through the list of employees from the employee query.

I've checked random sites to see how this can be done and only see the standard mouse event functions. Does anyone know how I can make this happen?