rs.Open "select * from reser where res_date between #" & Text1.Text & "# and #" & Text2.Text & "#", con, 1, 3
Run Time Error
No value given for parameters
Novice
Windows XP 
Access 2003
rs.Open "select * from reser where res_date between #" & Text1.Text & "# and #" & Text2.Text & "#", con, 1, 3
Run Time Error
No value given for parameters
Competent Performer
Windows XP Access 2007
you cannot use Text1.Text etc. - try Text1.Value or just Text1.
Novice
Windows XP Access 2003
Used as per sugessted, same error, i am giving Date as input to filter records in report
Competent Performer
Windows XP Access 2007
1. Are you using DAO or ADO? (I guess ADO which is not my area)
2. What is the , con, 1, 3 at the end sopposed to mean?
VIP
Windows XP Access 2003
I think con is the connection string to the database, the other variables I'm not sure about.
add this line right before your SQL code and see if you are getting return values for your two date fields
msgbox Text1 & ", " & text2
Make sure you are getting values for them first. If you are there's something wrong with the SQL statement, if you aren't it's something wrong with your retrieval of text1 and text2, are text1 and text2 on a subform or a main form?
If they're on a subform you may need to reference them like
forms!mainformname.subformname!text1
Administrator
Windows 7 64bit Access 2010 32bit
According to this link the syntax would be: forms!mainformname.subformname.FORM!text1Originally Posted by rpeare
http://access.mvps.org/access/forms/frm0031.htm
Posting Permissions
Reply With Quote