Default Value in a Table Field

[Olddogg]

Hi

I am building a Revenue Scan for my company. I am trying to build it as friendly as possible.

Here is my problem:

I am trying to make a default value in design view that depends on two other fields.

Amount
Agent
Agent Comp (the default value field)

are the three fields...

the default value has to be 30% of the Amount...
but it must only appear if and only if the Agent field is not Null (there is a name in it)

IS This Possible???

-----------------------------
Example 1

Amount $300
Agent
AgentComp 0

-----------------------------
Example 2

Amount $300
Agent Carla
AgentComp $90

 

[BobRodes]

You'll want to build a form. Build one, see if you can get it to work, and if you have trouble, post in the Access Forms forum.

HTH

Bob