Filtering a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a command button on my Project form which until now had code which
hid all completed projects whenever it was clicked. The code is:
Me.Filter = "Status <> 'Completed"

This works fine, but now I want it to filter out everything except those
projects whose status is "Not Started" or "In Progress". But I can't figure
out how to do it. Does anyone have an answer? Thanks very much in advance.

Janet
 
JanetF said:
I have a command button on my Project form which until now had code which
hid all completed projects whenever it was clicked. The code is:
Me.Filter = "Status <> 'Completed"

This works fine, but now I want it to filter out everything except those
projects whose status is "Not Started" or "In Progress". But I can't figure
out how to do it. Does anyone have an answer? Thanks very much in advance.
Click to expand...


Me.Filter = "Status = 'Not Started' Or Status = 'In
Progress' "
 
Back
Top