Form automation

[Coldsteel]

Hello all,

I have a few questions. I built a form and I want to upgrade it. I want to make certain fields required before a user can save. Also I want to automate a process I currently have. The user makes a selection in a cbo box which has 2 options (approved or denied). I have an update query which updates a price field on a table if the product is approved. I have to run this once a day to update all the approves. Does anyone know any examples or tips on how to do this?

Thanks

 

[Coldsteel]

I found a simple way to make some of my fields required. Here is the code I used, it works but is there a way to make it more proper?

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Len(Me.Refer & vbNullString) = 0 Then
MsgBox "Please fill out REFERRAL SPECIALIST Field"
Cancel = True
Me.Refer.SetFocus
End If
If Len(Me.ProdSpecialist & vbNullString) = 0 Then
MsgBox "Please fill out PROD SPECIALIST"
Cancel = True
Me.ProdSpecialist.SetFocus
End If
End Sub

I am still looking for a way to automate my update query with a cbo box. Any help would be greatly appreciated.