Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / December 2005

Tip: Looking for answers? Try searching our database.

OnCurrent Problems

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
albycindy - 09 Dec 2005 10:32 GMT
I have some code on my oncurrent event on my form (frmFollow) with subform
(frmClaims).  Some of it is working (the bits with *** behind the line) but
the rest isn't.  There are no errors when I cycle through the records or
enter new records, and the database compiles fine with no errors either. Does
anyone have any suggestions?

TIA

Private Sub Form_Current()

If Initial_Analysis.Value = "Editing Error" Then
Me!ProcessorName.Visible = True***
Else: Me!ProcessorName.Visible = False
End If

If Me!ProcessorName.Visible = True & Me!ProcessorName.Value Is Null Then
MsgBox "Enter Processor Name…", vbOKOnly
End If

If Initial_Analysis.Value = "Picking Error" Then
Me!PickerName.Visible = True***
Else: Me!PickerName.Visible = False
End If

If Me!PickerName.Visible = True & Me!PickerName.Value Is Null Then
MsgBox "Enter Picker Name…", vbOKOnly
End If

If Initial_Analysis.Value = "Credit for Overcharge" Then
Me!frmProducts!CreditforOvercharge = True
End If

If Initial_Analysis.Value = "Carrier Claim" Then
Me!CarrierClaim = True
Else: Me!CarrierClaim = False
End If

If Me!CarrierClaim = True Then
Me!frmProducts.Visible = False
End If

If Me!CarrierClaim = False Then
Me!frmProducts.Visible = True
End If

End Sub
Douglas J. Steele - 09 Dec 2005 12:09 GMT
Try replacing code like Me!ProcessorName.Value Is Null with
IsNull(Me!ProcessorName.Value)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I have some code on my oncurrent event on my form (frmFollow) with subform
> (frmClaims).  Some of it is working (the bits with *** behind the line)
[quoted text clipped - 44 lines]
>
> End Sub
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.