List box and command button.

[dlowry]

I've created a list box with employee names in it. when highlighting and clicking the search command button i've created it does nothing... can someone give me a code to use so when selecting the employee and hitting search it goes to that users information.

[Tanis]

What is the code you have so far? Table names, fieldnames and form name would help.

[MMcCarthy]

In the On Click Event of the button ('cmdSearch' for this example) put the following code.

 
Private cmdSearch_OnClick()
Dim stDocName As String
Dim stLinkCriteria As String
 
   stDocName= "Name of Employee record form"
   stLinkCriteria="EmployeeID=" & Me.ListBoxName
 
   DoCmd.OpenForm stDocName, , , stLinkCriteria
 
End Sub
 

I've created a list box with employee names in it. when highlighting and clicking the search command button i've created it does nothing... can someone give me a code to use so when selecting the employee and hitting search it goes to that users information.