On Double Click Open Form with two criteria
Windows 7 64bit 
Access 2010 64bit
Hello all ,
I have used and i am still using this function as its really helpful but today i need something more than that as i need multiple criterias on this VBA Code.
When i click on the Name of the Employee, i want to be transfer in the related field.
This is easy but now i need two criteria, such as the name of the employee as also the Season ID .
SeasonID basicly defines the Year such as 2012 ,2013.
So for this situation i want to transfer me in the form that a user has the correspont information about 2013 year only and not 2012.
If i i dont define the SeasonID all it will bring me all the results of 2012 and 2013
Here is how is my recently code:
DoCmd.OpenForm "EmployeeTable", , , "[EmployeeName] = '" & Me.EmployeeName & "'"
DoCmd.Close acReport, "AnnualLeaveDetails"
So now i need to modify it to be something like that [SeasonID] = me.SeasonID as also if i can define to bring me in Seasonid that equals to 2013=2
This of course should be a combination with the employeename.
Reply With Quote
