Search form with search button

Hi Gary

Thanks for the question

In general, you would first need to give your text boxes meaningful names.

Your code would then;

Declare string variables for Surname and Forename, and date variables for Offence Date and Birth Date.

You would then pass the values in the text boxes to the relevant variables. Note that all values in text boxes are text strings so you would have to use the cdate function to convert the date text box values into daye variables.

e.g.

dteOffDate = cdate(me.offdate.value)

finally you would create an SQL string with the variables embedded, this would look some thing like this;

"SELECT * FROM DATA WHERE Surname = & """ & strSurname & """ & " AND Forename" = & """ & strForename & """ & " AND Bdate"= "#" & dteBDate & "#" &" And OffenceDate" = " & "#" & dteOffDate & "#""

Finally, you would use thsi to open a DAO Recordset. This record set would then contain the data required

Hope this helps

Regards
Stephen