help with Access please (create a filter button)

[dragon7]

I have a combo box with different department in i
I have a button in a form called cmdShowDep

-When i open the form i have the combo box is set to not visibl
-When the Show only one Dept(cmdShowDept) button is clicked i want th
following to happe

-the combo box needs to be visibl
-the text caption of the button needs to be 'Show all Depatments' i
Re
-when a combo item is clicked i only want to show those records on th
form
-when the button is pressed with the red text 'Show all Departments'
it needs to change back to the black text 'Show only one Department'
and the combo box needs to disappear

any help with this would be good
thanx :shock

 

[[MVP] S.Clark]

Man... what professors don't make their students do these days...

in the cmdShowDept on click, make the cbo visible with

cboDept.Visible = True

And modify the caption of the Show Dept button

with cmdShowDept
if .caption = "This" then
.caption = "That"
else
.caption = "This"
end if
end with

Reverse the process for when the other conditions apply.