Validation on safe button on form

[MatthewJapp]

Hi there,

I have a form with a drop down control box with Actioned or Pending as selections. There is a save record button on the form.

How do I use validation to make sure either Actioned or Pending has been selected for this field on clicking the save? Maybe with a message to go back and enter the info?

Also, I have a subform below and want that to refresh the query each time the save button is pressed?

Any help will be greatly appreciated!!

Many Thanks,

Matthew - Manchester UK

 

[tinyevil777]

Change the field in question to a Required field?

 

[MatthewJapp]

how do you do that if you don't mind me asking?

 

[MatthewJapp]

also still the issue of refreshing the datasheet ... it's driving me nuts )

 

[JANR]

If the subform isen't linked to the combobox in a Master/child relationship then put this in the After_Update event of your combobox.

Private Sub NameOfCombo_AfterUpdate()
Me.NameOfSubformConteiner.Requery
End Sub

If your form is bound to a table or query the you validate controls in the Form_BeforeUpdate event.

Private Sub Form_BeforeUpdate(Cancel As Integer)
If IsNull(Me.NameOfCombo) Then
    MsgBox "Required Entry"
    Cancel = True
    Me.NameOfCombo.SetFocus
End If
End Sub

JR

 

[MatthewJapp]

supre, thanks for this code, much appreciated!

 

[JANR]

No problem

JR

 

[MatthewJapp]

Ah, I still can't get it to work (

Maybe I need to buy a book for dummies

 

[JANR]

What didn't work??

JR

 

[tinyevil777]

Open the table in Design View, find the field in question, change the "Required" option to "Yes"

This is the simplest way, you don't need to use code for this