filter wild card

  • Thread starter Thread starter Mark Kubicki
  • Start date Start date
M

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
 
Huh?
are you saying that i should add "*" to the row source table?


Rod said:
Hi Mark

Have you tried Like "*"?

Mark Kubicki said:
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
Click to expand...
Click to expand...
 
Back
Top