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 <*> 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/