Filter Data in a Form

[TaylorDF]

Hey,

I've been searching around for about an hour and I can't seem to filter a form to show only certain records based on a pre-defined list of requirements. I have a table with 300 entries and each one has 10 tick boxes and 10 data fields. I would like to add a button on the form when clicked will only show the records that have box1 and box2 ticked but still show all off the existing fields.

Using SQL I managed to make a query

'SELECT * FROM test1 WHERE [Quoted?] = True AND [Chased?] = FALSE'

although when I tried to put it into a macro

'Private Sub Command319_Click()

Dim SQL As String
SQL = "SELECT * FROM test1 WHERE [Quoted?] = True AND [Chased?] = False"


DoCmd.RunSQL SQL

End Sub'

But I can't get it to work.

Any help would be appreciated

Thanks,

Taylor

 

[stumac]

Are you trying to set the active form to filter based on this?

If so something like:

Dim SQL As String
SQL = "SELECT * FROM test1 WHERE [Quoted?] = True AND [Chased?] = False"
Me.RecordSource = SQL

if not then you will need to reference the form you want to update: Forms!myform.RecordSource = SQL

the RunSQL command wont create a new query and open it - it will just run the SQL in the background... ideal for an update or append query but useless for select. To do this you need to have a query already there, update the QueryDef and then use OpenQuery to open it.

 

[TaylorDF]

Thanks for that

Managed to get it working