link OLE image to record

C

cat

I am trying to set up a form with a land map showing sites 1 through to
100, each site is linked to its own record which has a combo box
selecting either Available, Pending or Sold. Each one is colour coded,
ie OLE001available is green, OLE001pending is yellow and OLE001sold is
red. etc for each site. I think I can do this using visible yes or no,
i.e. if site 001 is available then OLE001Available is Visible - Yes,
while OLE001pending and 0LE001sold are not visible? How do I link each
OLE for each colour and each site to the relevant record? so that the
correct colours are displayed on the form map.
 
Top