The way the form is to work is this...
1) The user selects a record from the combo box.
2) Depending on the record selected, thefield to the right of the combo box fills with data from the table, tblLots. This information is for the user's reference only.
3) Then also the field right under the combo box opens with a path to where the phots are. This path is dependant on the "PhotoLoc" info again coming from tblLots. There will be up to 6 images in any given folder.
4) Depending on the 3rd character in the key field in tblLots, a tabbed form will be visible. If it is a "C" then the Commercial tab should be visible. If it is a "R" then the Residential tab will be visible. In either case, the other tab is not visible. That is probably all the other code you are talking about. It does need to work this way.
5) Then, and of course here is the catch... depending on the path which has been autopopulated in the path field, the tab named "Photos" is to display the iamges in the folder related to the selected record in the combo box.