I have a list box that I'm filling with this sql statement. When the form loads I get a parameter value error that wants values for department and fppeDate.
Does anyone know why?
Me.OutPut.RowSource = "SELECT FPPE.LastName As [Last], FPPE.FirstName As [First], fppeSub.department As [Department], fppeSub.fppeNum As [FPPE #], fppeSub.fppeDate As [Date] FROM FPPE INNER JOIN fppeSub on FPPE.fppeID = fppesub.fppeID WHERE fppeDate >= #" & Me.txtBeginDate & "# " & _
"AND fppeDate <= #" & Me.txtEndDate & "# ORDER BY fppeDate"
The list box is housed on a form with a subform based on these two tables.
Thanks!!
Does anyone know why?
Me.OutPut.RowSource = "SELECT FPPE.LastName As [Last], FPPE.FirstName As [First], fppeSub.department As [Department], fppeSub.fppeNum As [FPPE #], fppeSub.fppeDate As [Date] FROM FPPE INNER JOIN fppeSub on FPPE.fppeID = fppesub.fppeID WHERE fppeDate >= #" & Me.txtBeginDate & "# " & _
"AND fppeDate <= #" & Me.txtEndDate & "# ORDER BY fppeDate"
The list box is housed on a form with a subform based on these two tables.
Thanks!!