Change picture based on the recordsource
Posted on 2011-02-27
I am trying to change the image shown on a continuous form based on the return value of the records field.
Using a subfrom that has a continuous form type
An image control (imgAsset)
RecordSource= "SELECT imgType From...."
imgType currently: 1 = img1, 2 = img2
(I can switch this in the sql to bring back the picture name if needed)
so basically on each row for the imgAsset I want this:
select case imgType
case 1: .picture = "img1"
case 2: .picture = "img2"
do I do this in the control source...what is the best way.