autofill a field base on the conditions of other fields

[dave john]

Hi im creating a data base that has a lot of calculations


well the problem is; i have a field [sub class] where i will enter either sb-1, sb-2 or sb-3, and so on... next i have a field [marketvalue], now if i enter sb-1 in [sub class] field i want that [marketvalue] to automatically enter 200 and if i enter sb-2 in [sub class] the [maketvalue] must be field with 300.....


any idea???
Please help me guys this project means a lot to me.... pls.... pls.... pls...

[Rod]

Too many 'sb-1' type possibilities for IIf() to be a practical solution!

OK, I think you are at the point of having to write a small procedure such as (off the top of my head):

Select Case Nz([sub class], "")
Case "sb-1"
marketvalue = 200
Case "sb-2"
marketvalue = 300
...
...
Case Else
marketvalue = 0
End elect

Place this in a private sub in the form's module and invoke it from the form's On Current and the [sub class] before update events.