Recent content by ksmithson

I solved it. I disabled the exit button, made my own, and added data validation code that must be satisfied before you can exit.

Not when you exit the form but when you go to the next record in the form.

I am trying to validate data that when the user goes to the form and goes from report #1 to report #2 is there are any nulls from report #1 it will not let them move on. Before and After Update requires that data has to be chnaged, right? What can I do to force validation if no data was...

The DoCmd.CancelEvent line did not work. Here is the code: Private Sub Form_Close() If Me.cboxTeamWorkScore.ListIndex = -1 Or Me.cboxReliabilityScore.ListIndex = -1 Or Me.cboxAdaptabilityScore.ListIndex = -1 Then MsgBox "Please select a score." DoCmd.CancelEvent Me.cboxTeamWorkScore.SetFocus...

Hey guys, I am looking for a way to prevent a form from closing until nulls in a combo box or text box are filled. I am currently using the Before Update event but if you close the form, Access will say that the reports in the form will not be saved. Is there anyway around this?

I am wanting it to where the end user has to input data by using combo boxes and text boxes and cannot leave any of them null. I do not want the validation to pop up an error message until they try to move to the next record. The error message will pop up and then set focus back to the nulled...

Here is the code: Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.cboxTeamWorkScore.ListIndex = -1 Then MsgBox "Please select a score." Me.cboxTeamWorkScore.SetFocus Cancel = True End If If Me.cboxReliabilityScore.ListIndex = -1 Then MsgBox "Please select a score."...

Hey, Thanks for showing me where I find the Before Update event in the subform. I am now having a problem where I put the code in the event, but nothing happens when I run the form and try to move onto another record when the combo boxes have nulls in them.

So I have to use the main Form's Before Update event to trigger validation in the controls in the subform? How do I reference the controls from the subform to the form? The Form has three subforms: sbfrmAttendance, sbfrmMetrics, sbfrmOtherMetrics

The subform does not have a Before Update option in the events tab, only Enter and Exit.

Hey guys, I'm new to using events in Access for forms and subforms. I am looking to make it that when the user moves on to another record in the form, it validates to make sure all combo boxes and text boxes are not null before you can continue onto the next record. I figured using the On Exit...