RE: [AccessDevelopers] If & Visible statement

Tue, 20 Dec 2005 07:30:23 -0800

Unfortunately on a continuous form, you can't. 
 

Tom Oakes
Personal PC Consultants, Inc.
[EMAIL PROTECTED]
503.230.0911 (O)
402.968.6946 (C)
734.264.0911 (F)



From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Joe
Sent: Tuesday, December 20, 2005 6: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


Please zip all files prior to uploading to Files section.



SPONSORED LINKS
Microsoft access developer Microsoft access help Microsoft access database
Microsoft access training Microsoft access training course Microsoft access programming

YAHOO! GROUPS LINKS



Reply via email to