Auto populated text box from combo field with a twist

[Stika]

Hi,

I have a auto populated text field from a combo box selection...the combo box is customers(combo11) and text field is pallet balance(text15)(both from the same table).

What I want to be able to do is if the value of the pallet balance is <0 just display 0 and update the table....is that possible? the reason I as is cause sometimes I get back more pallets then what the customer owes me and it would make it display as a negative value...which I dont want

[ItsMe]

The most simple answer is:

If Me.text15 < 0 Then
Me.text15 = 0
End If

The problem, as I see it, is you are storing a calculated firld in a table.

Beyond that, you only need to figure out where and when to execute the code provided here.