SOS. Please help!
i have a very simple thing that i'm trying to do.
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("SELECT Count(*) FROM Flights where Flights.Plane_ID.Value = '" & Me!Plane_ID.Value & "'")
rs.Close
Set rs = Nothing
but i'm getting the error: run time error 3061. Too few parameters. Expected 1
what can i do?
i have a very simple thing that i'm trying to do.
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("SELECT Count(*) FROM Flights where Flights.Plane_ID.Value = '" & Me!Plane_ID.Value & "'")
rs.Close
Set rs = Nothing
but i'm getting the error: run time error 3061. Too few parameters. Expected 1
what can i do?