MS Access open up field when particular option is selected.
I am in the process of creating an asset management databse in access 2010 for all our IT and electronic items.
What I am trying to do but don't know how to do is:
When I tick the box to retire an item I want another field to pop up on the form asking for a reason for retirement e.g. broken, not economical to repair. failed PAT etc.
Also, I am trying to integrate software licencing into the database so I can query a peice of software e.g. Crazy talk and know exactly which machines and how many licences are being used. I have created a table with the software names and serial numbers.
Any help would GREATLY be appreciated.
Thanks in advance. Jon