Another Form-Subform problem Sreedhar 11/18/2008 2:47:01 AM Hi, Can anybody please help on this ? I have a Form and a "Continuous Subform". Among others, there are two date fields (not the master-child) on both the main and the sub forms. While I navigate through the records on the main form, I want the date field (control) on the sub form whose value matches with that on the main form change its back color (highlighting). Here, the date field on the main form has only one value, but the date field on the sub-form has several values, 'cos its a continuous form. What code should I run to achieve this ? Where should I raise the event ? Thanks -- Sreedhar

Re: Another Form-Subform problem Tom van Stiphout <tom7744.no.spam[ at ]cox.net> 11/18/2008 4:26:27 AM On Mon, 17 Nov 2008 18:47:01 -0800, Sreedhar <Sreedhar[ at ]discussions.microsoft.com> wrote: Try conditional formatting. If it works, there is no code to write. -Tom. Microsoft Access MVP [Quoted Text] >Hi, > >Can anybody please help on this ? > >I have a Form and a "Continuous Subform". Among others, there are two date >fields (not the master-child) on both the main and the sub forms. > >While I navigate through the records on the main form, I want the date field >(control) on the sub form whose value matches with that on the main form >change its back color (highlighting). > >Here, the date field on the main form has only one value, but the date field >on the sub-form has several values, 'cos its a continuous form. > >What code should I run to achieve this ? Where should I raise the event ? > >Thanks