Number Range Requirement

[jdraw]

I found this using google

http://www.599cd.com/tips/access/afterupdate-event-vba/

 

[davies107]

will try to watch the videos and read the articles.

thanks again jdraw!

 

[davies107]

Can someone correct this code:

Private Sub lkpAssembly_AfterUpdate()
lkpQuery.Requery
If "Deck" = Nz(Me.LocalX, 0) < 5 Or Nz(Me.LocalX, 30) > 25 Then
MsgBox "Please enter a numeric value between 5 and 25"
Me.LocalX.SetFocus
Exit Sub
End If
End Sub


lkpAssembly - is the name of the combobox
Deck - is the chosen submodule in the combobox and its corresponding validation rule
LocalX - is the field/column where the validation must take place


*Sorry im not really good in VBA... hope someone can help me.

jdraw, i tried your statement samples but i could not get it right. same with John.