2 hours ago: Problem with the course links has been fixed, but you may need to clear your browser cache. See this post for details.  Dismiss
 
Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Large Check Box    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Large Check box Invalid null
Andrea Buckridge 
     
4 years ago
I have been using these large check boxes on my company form for a long time now. I tried to make a change with the form and now they won't work.  it keeps coming up with an "Invalid use of a null" error 94.  I have tried totally rebuilding my vba for the check boxes, but it still comes up with the same error.

Private Sub Customer_AfterUpdate()

    If Customer Then
        Customer.Caption = "P"
    Else
        Customer.Caption = ""
    End If
    
End Sub

Private Sub Form_Current()

    Customer_AfterUpdate
    
End Sub

Above is my coding for one of my check boxes.  Can someone help me figure out what I did wrong?
Adam Schwanz  @Reply  
           
4 years ago
What is the change you tried to make?
Andrea Buckridge OP  @Reply  
     
4 years ago
I posted earlier about my check boxes not working due to an error 94.  I now have them working on single forms. However, the "P" doesn't show up if I have more than one form open. You can tell the box is showing a true value because of the different color, but why does the "P" only work if there is only one form open?
Andrea Buckridge OP  @Reply  
     
4 years ago
I am trying to copy the CompanyF Several times so that I can use seperate forms from enetering different kinds of companies.  For example, I have Trucking Companies, Shops, Customers, Escorts, and Hotels.  all of which are saved in the CompanyT.  I have run into some frustrations when entering different types of companies (which are entered through different buttons.  I thought that if I had a form for each of the types of companies then I could set the default value for the correct type of company on that specific form to yes, and avoid making the mistake of forgetting to designate the company type.  Each company type has a check box. I have since figured this out though I think.  I watch the extended cut again and built a function for it.  That seems to have fixed my problem.  Thank you for your time.
Scott Axton  @Reply  
        
4 years ago
Andrea --

See the Too Many Tables video.  Also, watch the Normalizing Data video.
Those two videos will give you a good start.

Please don't use the yellow "Start a New Conversation" unless it is a different problem.  Conversations get too broken up and to hard to follow.  Use the blue "Post Your Reply" instead.

-----

Alex or Richard would you combine this post into this one?

Done -R

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Large Check Box.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 6/24/2026 5:04:52 PM. PLT: 1s