VB6 Indexing

I am attempting to layout a floor plan so that the background color of the label boxes, (rooms), is different for vacant rooms. Upon click_on the room, if empty, the room number is input to a form that is filled out for the new occupant. If the room is occupied, then clicking on the room will display info about the occupant that is maintained in a database.

I am having a problem tying together the empty room number to the empty form to update the databse. I also am having a problem in referencing the database using the room number.

Thanks