PC Review


Reply
Thread Tools Rate Thread

Checkbox in an If statement

 
 
JuanManuel
Guest
Posts: n/a
 
      13th Jun 2008
Upon saving, I'm trying to show a messagebox when none of the 4 checkboxes in
the document are checked and to cancel saving.

I'm using checkboxes from the control toolbox.

It's giving me an error on the If statement called: Run-time error '424".
Object required.

This is the code that I'm using:

Sub FileSaveAll()
If ChkboxTMS1.Value = False And ChkboxTMS2.Value = False And
ChkboxTMS3.Value = False And ChkboxTMS4.Value = False Then
MsgBox "Please select a radiobutton and retype your changes."
Exit Sub
Else Documents.Save
End If
End Sub

Any thoughts?

Thank you

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Coordinate status of checkbox on form to checkbox on multiple reco DanRoy Microsoft Access 0 4th Sep 2008 09:18 PM
If statement with checkbox =?Utf-8?B?VHJhZGVyQW5hbHlzaXM=?= Microsoft Access Forms 3 16th Jul 2007 03:54 PM
multiple if one then statement using checkbox =?Utf-8?B?ZzI4ZG1hbg==?= Microsoft Access 1 5th Apr 2006 10:02 PM
Set CheckBox or Radio in repeater with if statement Mick Microsoft ASP .NET 1 4th Jan 2005 01:42 PM
Master-Detail Datagrid -checkbox (once tick the checkbox, all the child checkbox is ticked) Agnes Microsoft VB .NET 0 16th Aug 2004 11:23 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:08 PM.