G
Guest
I've got a continous form that I'm hoping to use to moniter a manufacturing
plant's production status. Some of the many fields consist of a Part Number,
Run Qty, and various different processes. My idea is that each applicible
process has a number value indicating what order it needs to be done.
Double-clicking on any of these process feilds will bring up a form asking
the status (Process open or Process Closed). Ideally, if Process-A's status
was set to Open, the backcolor would be yellow. If it were closed, dark grey.
I've figured out how to set the backcolor on the field, no problem there
with a little bit of coding. The problem is that the color is changing for
all of the records in form view, where I need each records colors to be
different.
Does anybody know, if possible, prefereably without much coding, that I can
manipulate the colors to react to a record-by-record basis rather than the
entire form?
As usual, thanks in advance for any advice on the subject.
Jack
plant's production status. Some of the many fields consist of a Part Number,
Run Qty, and various different processes. My idea is that each applicible
process has a number value indicating what order it needs to be done.
Double-clicking on any of these process feilds will bring up a form asking
the status (Process open or Process Closed). Ideally, if Process-A's status
was set to Open, the backcolor would be yellow. If it were closed, dark grey.
I've figured out how to set the backcolor on the field, no problem there
with a little bit of coding. The problem is that the color is changing for
all of the records in form view, where I need each records colors to be
different.
Does anybody know, if possible, prefereably without much coding, that I can
manipulate the colors to react to a record-by-record basis rather than the
entire form?
As usual, thanks in advance for any advice on the subject.
Jack