Enter Paramenter Error (1 Viewer)

kawai6rr

Registered User.
Local time
Today, 11:08
Joined
Aug 26, 2009
Messages
21
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!!
 

boblarson

Smeghead
Local time
Today, 11:08
Joined
Jan 12, 2001
Messages
32,059
Please don't use Photobucket or other file sharing sites here. There are several of us who have that blocked at work so we can't see it. It is very simple to just upload it to this forum and then reference it so it is an inline image. See here for how to do that.

As for your parameter prompt, it is usually that something either doesn't exist in the source you are trying to use or is spelled incorrectly.
 

Users who are viewing this thread

Top Bottom