inserting a value of a field depending on the value of another field

[fuadmab]

if field a equels value then field b equels another value, how can i construct the code in V.B , i tried but did not work
thanks

[QVeen72]

Hi,

Not clear.. but you can try this :

[code=vb]
If RST("A") = 100 Then
RST("B") = "Whatever"
Else
RST("B") = "Default"
End If
[/code]

Regards
Veena