Need some help

[oc737]

I currently have a form that allow me to access multiple forms via 4 command
buttons. Is it to have the button color change if any record in the form
(that the button directs you to) is a certain value? Their are several
status values to these records (Open, Closed, In Work), and I would like the
color of the command button to change if any record is "Open".

 

[Jeff Boyce]

I'm missing something...

It sounds like you are using 4 command buttons to open four new forms. But
you want to have the color of the command button change if the (newly
opened) form contains any records ... how can you (still) see the command
button if the new form is opened?

Another approach, and one that uses less "real estate" on your screen, would
be to use a combo box that lists the possible states (three or four?), and a
single command button that opens the relevant form, based on which state was
selected.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[ekomsky via AccessMonster.com]

On the second sentence I left out a word, should be "Is it possible..."

You can't change the color of a cammand button, but you could change teh
background of a label or a text box, (one of those) format it to look like a
button, and program it to open your forms.

 

[oc737]

The one command button goes to a log book, and is what is most used. The
other 3 buttons open discrepancy reports, hardware repair, and parts
requisition. These are not used often. What I would like is for the command
button to change color or change in some way as a flag that you must go to
those forms to check out what has changed. For instance, if I request a part,
when my manager opens the original form to check the logbook, he will see
that the button for requisition has changed, and go there instead to check
out what is needed. Of course, then, if he has checked that out, he can go
to the bottom of that form and click on another command button to open any of
the other forms. Hope this makes sense.

I'm missing something...

It sounds like you are using 4 command buttons to open four new forms. But
you want to have the color of the command button change if the (newly
opened) form contains any records ... how can you (still) see the command
button if the new form is opened?

Another approach, and one that uses less "real estate" on your screen, would
be to use a combo box that lists the possible states (three or four?), and a
single command button that opens the relevant form, based on which state was
selected.

Regards

Jeff Boyce
Microsoft Office/Access MVP
[quoted text clipped - 5 lines]

On the second sentence I left out a word, should be "Is it possible..."

 

[Pete D.]

If you only have those three you can use a traffic light series of text
boxes and conditional formating.