How a insert a value to an access filed based on a codition of anotherfield

[deepika sivarj]

Hi, Im creating a Online assessment form using Infopath and Access database 2003 as the backend. Suppose I have two filed in db sich as A and B(A has user entered value and B has the correct value already stored). My requirement is to compare the values of these fields and if A = B, I need to insert a value into another field say C.
How can get the value automatically inserted into field C if A = B.


Submitted via EggHeadCafe - Software Developer Portal of Choice
How to Annotate Images from a database in a web page
http://www.eggheadcafe.com/tutorial...9-082c24acd999/how-to-annotate-images-fr.aspx

 

[Andrej]

Have you allready tried to create a rule on fields A and B.

define a condition in the rule, so the rule just fire if A==B.
add an action to the rule to set the field C and submit data if necessary.

the rule will fire after user change the value in the field. for this reason
you have to create the same rule on both fields A and B.

bg Andrej