[RESOLVED] List box opening new populated Form [Figured it out check out the code]
What I am trying to do is an employee database.
I want to select an employee from a list. It bring up the information on my screen. I have this working. But I also want it to bring up another form with that employee's information on it. IE first form is employee contact information. 2nd form is work information department, pay and so one. I allready have this 2nd form. I just want to be able to pull up Joe Smith and it pull up his information and the 2nd form as well.
Any ideas?
Re: List box opening new populated Form
I figured it out. Incase any one wants to know here it is
Code:
Private Sub List0_DblClick(Cancel As Integer)
Dim stfrmName As String
Dim stLinkCriteria As String
stfrmName = "form name"
stLinkCriteria = "[ID]=" & Me![List0]
DoCmd.OpenForm "form name", , , stLinkCriteria