Got it! It took awhlel to sink in but you guys are right, you can't display a different image for each record when in continuous form mode on a subform. Attacked from a different angle.
--- In [email protected], "boozilla2000" <[EMAIL PROTECTED]> wrote: > > I have two subforms on my main form. I want the records on subform B > to correspond with the records on subform A which they do. However, > I want the records on subform A to let me know if there is a > corresponding record on subform B without having to go to subform B > to see for myself. Take a look at the screenshots of what I am > trying to accomplish at http://www.chemreport/test/helpme.htm > > Main Form = ChemicalInventory w Primary IDPartNo > Subform A = EditSuppliers w Primary IDSupplier & Foreign IDPartNo > Subform B = MSDSDocs w Primary IDMSDS & Foreign IDPartNo & Foreign > IDSupplier > > The code on sfMSDSDocs oncurrent event is: > > Forms![ChemicalInventory].[EditSuppliers].Form! _ > imgRedDot.Visible = IsNull(Me.LocalScanLink) > > Forms![ChemicalInventory].[EditSuppliers].Form! _ > imgGreenDot.Visible = Not IsNull(Me.LocalScanLink) > > Can this be done? I am a novice with little syntax so I need help > with code if this can work. Thanks group. > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
