Help on a design, please!!

  • Thread starter Thread starter dplove
  • Start date Start date
D

dplove

I have a form called "software info". In this form is a subform with the
license number for the software. I have also created a "check out/in" form
for the software. In the software form I have a button that I can click on
that will open the "check out/in" form in order for me to put in the info
when someone borrows the software.

Here is what I would like to happen after I have inserted the info into the
"check out/in":
When it is checked out I would like, maybe a red button or something, that
says that the software has been checked out. Also when it returns I would
like for the above red button to uncheck or disappear. Can this be done and
how?

Thanks
 
You can just have a blank LOCKED textbox control and set the background color
programmatically. I don't think you can have a blank LABEL control (I think
it's got to have at least one character in it). But in any event,
programmatically setting the background color in VBA based on a table value
is a fairly trivial task.

One thing however: every time I ever tried "doing something" on a subform,
the change carried over to EVERY record in the subform. Drove me absolutely
NUTZ. I still don't understand WHY Access does that.

FYI....

Or, you can have a bound checkbox to the table which shows checked or not,
and you can change the background color of the checkbox depending on the
value in that field, or ever make it visible/invisible. Note that my caveat
above may still apply.
 
Back
Top