Re: filter wild card

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


"Rod" <Rod@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:90419CF7-A21A-4D02-96FE-E51DD9B074A9@xxxxxxxxxxxxxxxx

Hi Mark

Have you tried Like "*"?

"Mark Kubicki" wrote:

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





.