Need Help with values from tables as parameters

[Arvin Villodres]

Happy New Year to everyone!

I have a table named tblContributions and this table
consists of the following fields:

MinContrb - minimum contribution
MaxContrb - maximum contribution
MyShare - my share
EmpShare - employer's share

all in Number(Double) format

in a different form having a different record sourceI have
this text
boxes named txtEquivalent1,
txtEquivalent2, txtFirstContrib and txtLastContrib.

The value that should appear in the txtEquivalent1 while
the form is
open should be MyShare and txtEquivalent2 should be
EmpShare if the
sum of txtFirstContrib and txtLastContrib falls within
the range
of MinContrb and MaxContrb.

I have tried a different approach not using a table, but
instead, I
used a case statement within the form. But the problem is
if I have
to update the MyShare and EmpShare values I still have to
open the
source code.

Could you help me with this one?

Thanks very much for the help.

 

[MacDermott]

It sounds as if you need to specify which record from tblContributions you
want to use.
If you know that, the DLookup function might be helpful.

HTH
- Turtle