Search results

Row Source of the list box is: SELECT tblLeaveDetail.Shift, tblLeaveDetail.District, tblLeaveDetail.Employee_ID as Star, [tblLeaveDetail.Last] & ', ' & [tblLeaveDetail.First] as Deputy, tblLeaveCode.Type, tblLeaveDetail.Hours, tblLeaveDetail.Remarks FROM tblLeaveCode INNER JOIN tblLeaveDetail...

So am I able to reference the names of list boxes from forms on the report? I tried to do a Me.lstEvents.ListCount - 1 in the code on teh report As lstEvents is the name of the list box on the form, but I get a compile error: Method or data memeber not found and it takes me to that lstevents...

hmm that is interesting, although mine isn't a selection, it's just a click a date and get all employees that day working sent to the list box at the top. I know that this is generating that info in some form: strSQL = "SELECT tblLeaveDetail.Last, tblLeaveDetail.First, tblLeaveDetail.Date...

So I tried just having: DoCmd.OpenReport "rptDailyETSB" for the onclick event of that button and all it does now is act like it is sending a print job to the printer although nothing ever prints out and the report doesn't come up on the screen.

I have been trying to wrap my head around this but I keep spinning my wheels and running into walls trying to get this to work. So I inheritied this Access database from previous guy in this position, and I am trying to add a button to one of the forms in the file and have that button open a...