Filter > today's date

[SDS100UK]

Hi,

Ac xp

I have a form bound to a table.

The form has a list of shows along with the date of the show

I have an unbound check box in the header of the form that when it is ticked I want to just show the shows that have a 'show date' greater than todays date and when not ticked shows all shows (inc those that have passed)

I have the following code in the BeforeUpdate of the check box.....
If Me.chkFutureShows = -1 Then
Me.Filter = Me.ShowDate > Date
Me.FilterOn = True
Else
Me.FilterOn = False
End If

What is wrong? As it will not work. It shows me all shows which ever option is selected.

TIA


Steven

 

[M8KWR]

put the code into the on_click procedure.

It works for me..

Hoep this helps.

 

[TheAceMan1]

How are ya SDS100UK . . . . .

[blue]Me.Filter = "[ShowDate] > Date"[/blue]

See Ya! . . . . . .

 

[SDS100UK]

ACEMAn youre FANTASTIC!

That worke dgreat.

Thank you somuch. Its odd how something so little can drive you insane - and the answer is so simple!

Thanks again.