Linking pictures from requery of cascading combo box selection

[willfrank]

How do I link pictures to a cascading box selection, that has a requery until selected. Code on Form Current and Image14 code below:



Private Sub Form_Current()

Select Case RoomID.Value

Case "US-PLB-3-1243"
Image14.Picture = "C:\Users\franklw2\Desktop\DatabasePictures\1243.p ng"


End Select


Private Sub RoomID_Click()
Select Case RoomID.Value
Case "US-PLB-3-1243"
Image14.Picture = "C:\Users\franklw2\Desktop\DatabasePictures\1243.p ng"
End Select