Search results

will try although I cannot see an option to save in that format. using 2010 version

Sorry Bob, I have tried the code you posted and when I click the next button without selecting a check box nothing prompts me to do so. It is not grumbling about finding the control so it must be accessing it ok? sorry to take your time like this. I have been stuck for several days now on this...

perhaps a screenshot may help: https://www.dropbox.com/s/wn1n8e326uns22o/accessform.jpg

Hi again. I have just put the validation statement in the sub-form before update event and it totally ignores it. I click the insert record button, enter details without checking a check box, then click the next button and nothing happens in regards to validation. This is really frustrating...

thanks, I did not think of the sub-forms event.

Sorry for bumping this but I would really appreciate any advice

Sorry it does not work. As soon as I dismiss the messagebox and try to click the check box nothing happens. Is it because the subform is really a representation of the underlying table? I have not added the checkbox to the subform it is visible as a check box because the table field is a yes/no...

here you go: Private Sub Form_BeforeUpdate(Cancel As Integer) If (Me.frmContactType.Form.chkAssociate = 0) Then MsgBox "Please select associate" Cancel = True End If End Sub I also get a dialog of you can't go to specified record

Hi, I have validation on a checkbox on a sub form and after the validation fails and the cancel = true is executed in the before update event, I am unable to select the checkbox on the form. Access will not allow the selection. Any ideas would be appreciated. Hope this is the right forum. my...

Hi Bob, that is where I want to validate the checkboxes, but do not know how to properly access them. If I have a main form then sub form then a check box called chk1 on the first sub form would the syntax be like this in the before update event?: if (Me!Subform1.Form!chk1 = 0) then msgbox "You...

Hi, I have created a form with sub form and added navigation controls as well as save and delete buttons etc. It all works fine. The only issue I have now is that the subforms are in datasheet view and I cannot seem to change that. Also could you please advise on how to reference controls on a...

Thanks again. Thats useful to know.

no objection just limited knowledge of them and formatting them. I will have a go at using them and see how I get on. Thanks.

Hi, the form is to enter new contacts. I am using three tables and the reason I went with an unbound form is that I could not get the foreign keys written to the other two tables on update without inserting them manually. The only way I could get it to work automatically was to use a bound form...

As an aside, I have the same code attached to the before update event of a bound form which works correctly, using the cancel = true instead of the exit sub each time. I wonder if the problem is because the form is unbound?

I tried your code in the before update event with the rest of the code in the click event of the command button. I then tried moving all of the code to the before update event and it did nothing. I also have three SQL insert statements in the click event. should I move these as well?

hi, sorry for the delay, the site keeps logging me out. I have tried that code and it still does not work. I have the other textboxes on the form validating in the same box of vba code, will this be causing the problems? as an example this precedes the checkbox validation and similar code...

Hi, I am trying to validate that the user selects at least one checkbox out of three on the form in Access 2010. They can select one, two or even all three if they wish, but at least one must be checked. I am using the following code attached to the click event of a command button. It was fine...

Hi, I have just joined. I am fairly new to Access and have only been programming since last summer. Mainly VB.Net, HTML/CSS/PHP and some C++.