filter wild card

[Mark Kubicki]

i have a form whose records can be filtered based on the value of a combo
box (on that form) (cboSourceFilter)
the combo box gets it's values from a user entered table

my problem is:
i can filter "down" toa specific criteria, but can't seem to find a way of
adding a wildcard to the list to return to displaying all of the records
i could use an option button to see the list filtered or not; but would
rather use a " * " at the top of the list



Private Sub cboSourceFilter_Change()
On Error GoTo Err_cboSourceFilter_Change

Me.Filter = "[Source] = '" & Me![cboSourceFilter] & "'"
Me.FilterOn = True


thanks in advance,
mark

 

[Rod]

Hi Mark

Have you tried Like "*"?

 

[Mark Kubicki]

Huh?
are you saying that i should add "*" to the row source table?

Hi Mark

Have you tried Like "*"?

i have a form whose records can be filtered based on the value of a combo
box (on that form) (cboSourceFilter)
the combo box gets it's values from a user entered table

my problem is:
i can filter "down" toa specific criteria, but can't seem to find a way
of
adding a wildcard to the list to return to displaying all of the records
i could use an option button to see the list filtered or not; but would
rather use a " * " at the top of the list



Private Sub cboSourceFilter_Change()
On Error GoTo Err_cboSourceFilter_Change

Me.Filter = "[Source] = '" & Me![cboSourceFilter] & "'"
Me.FilterOn = True


thanks in advance,
mark