MS Access 2007 - Open form, and set rectangle visible property to true based on textbox value
Posted on 2010-08-26
I have an assets form that contains assets information to include LocationID (txtLocationID), data range 1011 -1199. Next to it I have placed a label (lblFindIt), that I would like to open a GIU like form that displays a layout of the building, and the rooms in it. On the GUI form I have place small red rectangle to show were each desk is within a room, I have labeled them bx1011 - bx1199, to represent all the possible desk locations. I have set the rectangles visible property to false.
Now, the tricky part, I would like when the user clicks on lblFindIt, the GUI form (frmBldg4413Layout) opens, and the box with the corresponding LocationID of the current record for frmAssets has its visible property changed to true.