Help needed please (1 Viewer)

[basehumax]

Hi All

Please help i am looking vba to warm if the field entered 70 or above please have look the database

Thanks

 

[June7]

Yes, can annoy users with a popup they have to respond to. Trick is figuring out what event to put code into. Could use the textbox AfterUpdate event.

Private Sub Weight_AfterUpdate()
If Me.Weight >= 70 Then MsgBox "text here"
End Sub

Or can have a permanent label with big red text with that information.

 

[basehumax]

Yes, can annoy users with a popup they have to respond to. Trick is figuring out what event to put code into. Could use the textbox AfterUpdate event.

Private Sub Weight_AfterUpdate()
If Me.Weight >= 70 Then MsgBox "text here"
End Sub

Or can have a permanent label with big red text with that information.

Thanks but how can i do the big red label please thanks

 

[essaytee]

Thanks but how can i do the big red label please thanks

Create a Label control on your form, name it appropriately.

Add code in the Form's OnCurrent Event, as follows, substitute for your control names.

Private Sub Form_Current()
    If Me.Weight > 70 Then
        Me.lblMsg.Caption = ">70 - special message"
    Else
        Me.lblMsg.Caption = "< 70 - whatever message"
    End If
End Sub

The above is the bare bones of what is required. All you have to think about now is how to account for when you edit your weight value, the clue is in June's post.

 

[missinglinq]

Cross-posted and answered extensively at

https://www.utteraccess.com/forum/index.php?showtopic=2052951

Linq ;0)>