Related Table Value on Form Load for comparison in control

[SimonPGreen]

Hi,

Can anyone point me in the right direction on the best way to achieve the following:

Two Related Tables 1:Many with from bound to each
Packages Applications

On open or current event on Packages form do the following (shown in psuedo mixed code for clarity(ish)):

curTempAppValue = Select TOP 1 applications.curForecastValue from Applications where applications.FKPackageRef = Form!Packages!txtPKPackageRef ORDER BY applications.intValuationNumber DESC

If Me!curLetterOfIntentValue.value <= curTempAppValue me!curLetterOfIntentValue.Backcolor = 255

Appreciate any advice.

Simon

 

[ThomasLafferty]

Have a look at conditional formatting -it works in a similar way to the way it does in Excel.

Tom

Born once die twice; born twice die once.

 

[PHV]

Perhaps this ?
curTempAppValue = DLookUp("curForecastValue", "Applications", "FKPackageRef=Forms!Packages!txtPKPackageRef AND intValuationNumber=" _
& DMax("intValuationNumber", "Applications", "FKPackageRef=Forms!Packages!txtPKPackageRef"))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SimonPGreen]

PHV,

Top answer as always - thanks.

Simon