Queries, forms and check Boxes

[bjjazzyjones]

I would like to create a query that will modify its results based a a check box associated with a field on a form.

IE if a user wants their results to be based on a date field, they would check a box, and the query return results based on that check box and field.

How do I do that?

 

[LittleSmudge]

I think what you want is something like

Dim strSQL As String

strSQL = "SELECT * FROM tblTableName "


If tickBox Then
strSQL = strSQL & "WHERE dateField .. .. etc. .. .. ;"
Else
strSQL = strSQL & "WHERE .. .. some other criteria .. ;"
End If

DoCmd.RunSQL strSQL




Does that help ?

G LS