automatic text field update based on previous text field value

[aminkassar]

Hi guys,

I really need some help over here. I have one text box called 'Base Fee' and another called 'Results'. What I want, is to enter a value in 'Base Fee' and get an automatic text update in 'Results'. I have been using VB in MS access, but with no success. Here is what I have so far. Please note I suck at programming.

Private Sub Base_Fee_AfterUpdate()
Dim msg As String
If 0 < Me.Base_Fee > 250001 Then
msg = "Rounded Down to the Nearest $1000"
Results = msg
End If
End Sub



What am I doing wrong. Also if there is an alternative please let me know.

Thanks

[pbaldy]

I'm not clear on what your test is intended to be, but the syntax is wrong. Here's a guess:

If Me.Base_Fee > 0 AND Me.Base_Fee < 250001 Then

Also this should be:

Me.Results = msg

[aminkassar]

Hi there,

I actually managed to find an alternative. But much appreciated nonetheless.