Text box disable

[bells]

Hello all I have the following question using Ms access 2010

I have two text boxes where depending on what is entered on the first the 2nd disabled.
that works fine
but if I make a mistake and enters a value on the 2nd while it is was enabled and return back to the first and enters a value which disable the 2nd, it disable it ok but keeps the value and even save it to the table. any idea why this is happening. thanks in advance.

Private Sub q300_AfterUpdate()

If Me.q300 = "1" Then
Me.q300_1 = ""
Me.q300_1.Enabled = False
Me.q301.SetFocus
Else
Me.q300_1.Enabled = True

End If
End Sub

 

[missinglinq]

In the underlying Table, is the Field that q300 is Bound to defined as Text or as a Number? If it's defined as a Number you need to drop the Quotation Marks.

So, if q300 is defined as a Number

Private Sub q300_AfterUpdate()

If Me.q300 = 1 Then
  Me.q300_1 = Null
  Me.q300_1.Enabled = False
  Me.q301.SetFocus
Else
  Me.q300_1.Enabled = True
End If

End Sub

If q300 is defined as Text

Private Sub q300_AfterUpdate()

If Me.q300 = "1" Then
  Me.q300_1 = Null
  Me.q300_1.Enabled = False
  Me.q301.SetFocus
Else
  Me.q300_1.Enabled = True
End If

End Sub

Hope this helps!

There's always more than one way to skin a cat!

All posts/responses based on Access 2003/2007

 

[randy700]

Perhaps you should clear any values in the text box before you disable it?



Randy

 

[missinglinq]

That would be what the line in red does:

Me.q300_1 = Null
Me.q300_1.Enabled = False

Hope this helps!

There's always more than one way to skin a cat!

All posts/responses based on Access 2003/2007

 

[bells]

Thanks Guys

the problem was not the code. I changed the data type fro text to numbers and works very well now

thanks for all responded