As Tom said, you can't do this on continuous forms. Instead, you might consider the use of conditional formatting. You can set certain controls to be enabled/disabled based on other values in the record.
I am pretty certain conditional formatting can make a control visible or not visible, however. The best you can do is enable/disable controls. Eric > -----Original Message----- > From: AccessDevelopers@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of Joe > Sent: Tuesday, December 20, 2005 7:51 AM > To: AccessDevelopers@yahoogroups.com > Subject: [AccessDevelopers] If & Visible statement > > I have a few statements that I am useing to make an item > visible if somehting is populated. But I think I'm doing > something wrong. If the field is populated for one item all > the forms are affected. I am using a continious view on my > form. How would I set it so it is only making the field > viewable for that one record. > > I have a main form with Tabs and then each tab has a subform > on it too. > > > > Private Sub Declined_AfterUpdate() > If IsNull(Me.Declined) Then Me.DeclinedNotes.Visible = False Else > Me.DeclinedNotes.Visible = True > End Sub > > Private Sub LeadGenerator_AfterUpdate() > If IsNull(Me.LeadGenerator.Value) Then Me.LeadGenerator_Other.Visible > = False Else Me.LeadGenerator_Other.Visible = True > End Sub > > Private Sub NotAwarded_AfterUpdate() > If IsNull(Me.NotAwarded) Then Me.NotAwardedNotes.Visible = False Else > Me.NotAwardedNotes.Visible = True > End Sub > > > > > > > > ------------------------ Yahoo! Groups Sponsor > --------------------~--> > Most low income homes are not online. Make a difference this > holiday season! > http://us.click.yahoo.com/5UeCyC/BWHMAA/TtwFAA/q7folB/TM > -------------------------------------------------------------- > ------~-> > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > > ------------------------ 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/
