Search results

My problem is I don't know VBA code. It is something I would like to learn, but haven't done it. Thus I don't know how to put a stop in the validation code. The code is in the BeforeUpdate event.

I check the box “Authorized to Preside…” I go to the select combo box in the form header to select another person. I am asked if I want to save the changes. I indicate yes. Then it tells me I need to choose a church. I click OK I choose a church in the combo box. I then get the error message...

I still get the error message: Update or CancelUpdate without AddNew or Edit. HOWEVER, it works if I used the navigation button at the bottom--and not the combo box I have in the form header!!

What I want is that if the "Authorized to Preside..." checkbox (txt authorized) is checked (true), then I want the church field (txtChurchCombo) to not be null, to become a required field. The church field to be conditionally required, if the "Authorized to Preside..." is checked.

I have attached a test db that has the form and I added some records. However, in this db when I check the checkbox "Authorized to Preside..." and do not choose a church, I don't get the message that I must choose a church.

So, what is to be included in a test db? I'm warning you, my dbs aren't pretty!

I created a new simpler form. This is the code in BeforeUpdate: Option Compare Database Private Sub Form_BeforeUpdate(Cancel As Integer) If MsgBox("Do you want to save the changes for this record?", _ vbYesNo + vbQuestion, "Save Changes?") = vbNo Then Cancel = True Me.Undo ElseIf...

I deleted the beforeupdate event, and typed the code back in. I tried the the form, and checked the authorized box. It did ask me if I wanted to save the changes. I responded yes. Then it informed me that I needed to choose a congregation, which I did. That's when I get the erro4r message. When...

I removed the other code for the before update event

I get an error message: Update or CancelUpdate without AddNew or Edit

I have a form in which I have a check box to indicate whether a member is a ruling elder. Another field is a combo box with the names of churches. If the ruling elder box is checked, I want the church field to be required. I know very little VBA, so I copied one that I hoped would work...

I am retired after working 40 years in the non-profit world . I have lived all my life in the mid-west, except for three years in New Jersey for graduate school. I have used Access quite a bit, but know VERY little VBA.