Filter by selection off of form button

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

Guest

Hello, I've created a schedule database that tracks current company jobs.
Each job has a job owner. There is a form in the database that scrolls
though each open job that includes owner, date due, etc.. I'm trying to
create a button on a form that when it is clicked will only show the current
showing owner's jobs. I've tried to use the me.filter command with no luck.
It works so great when you click on "filter by selection" I just want to
create a button that does that. Thank you.
 
Using the Click event of your button
Me.Filter = "JobOwnerName = " & "'" & [JobOwnerName] & "'"
Me.FilterOn = True

("'" = single ' enclosed by 2 "s)

hth
Al Camp
 
Back
Top