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 BuckridgeOP
@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 BuckridgeOP
@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.
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
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Large Check Box.