Help on a design

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

I have a similar application. What I use is an Option Group with two Toggle
Buttons. One says Check Out and the text is red. The other says Check In
and the text is green. There is a Boolean field in the table that indicates
whether a record is checked in or out. If it is Checked In, The Check In
button is disabled and if Checked out, the Check Out button is disabled. I
use the After Update event of the option button to update the checkout field
in the table and enable and disable the correct buttons.
--
Dave Hargis, Microsoft Access MVP


"dplove" wrote:

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