Click on a Record from a Continuous Subform to open a Report

[whojstall11]

I have a form called GetdataFrm. Within it i have a combo box that filter a query. When the combo filters, it populates a continuous subform called GetDataQrysubform. GetDataQrysubform look like a table that contains this Jobcode information:



EmployeeID Jobcode CardAccess Folders Software


When I filter the GetDataFrm form, I want to be able to click on a Employee's EmployeeID number from a single record in GetDataQrysubform and then a form called SingleRefrm would pop up taking me to that record.
So far I have a event procedure coded to open up SingleRefrm, when the EmployeeID field is clicked but its not working. The code looks like this:

 
DoCmd.OpenForm "SingleRefrm", acNormal, , "EmployeeID = '" & Me.EmployeeID & "'"

Attach is a screen shot of the GetDataFrm.
Doc2.doc

[pbaldy]

What does "not working" mean exactly? If EmployeeID is a text field, that code looks fine.

[whojstall11]

It wont open the SingleRefrm form at all, it is a text field as well.

[pbaldy]

What event is the code in? Does any code run?

[whojstall11]

The event is on an on click event. It doesnt run and its not giving me any errors.

[pbaldy]

Can you post the db here?

[whojstall11]

Here is my db
NewEmployeeTemp2thisworks.zip

[pbaldy]

Curious. It works in the double click event but not the click event. Offhand I'm not sure why but I have to head out for lunch before I get cranky.

By the way, it won't appear to be working when it opens the second form because all the controls are unbound.

[whojstall11]

Wow thank you. I changed the event from click into double click and had it link to my report I have been playing around with and it worked. Thank you again. Enjoy your lunch!!!!!

[pbaldy]

I did! Happy to help.