How to update only one field in a form? (DLookup / recalc / requery)

[deewe]

Hello,

On an LostFocus event I'm trying to update another field that is tied to a DLookUp query.

I'm able to update all the form fields but I don't find a way to update only one field.

The below tests update all the fields

- Me.Recalc
- Me.Controls("Txtbox_RatioDev2").Recalc
- Me.Requery
- Me!Txtbox_RatioDev2.Requery
- Forms("Description").Controls("Txtbox_RatioDev2").Requery
 

Theses examples are not working:

- Me.Controls("Txtbox_RatioDev2").Recalc
- Forms("Description").Controls("Txtbox_RatioDev2")
 

So is it possible or am I stuck to requery and so update all the form?

Thanks.

[ADezii]

@deewe
The Recalc Method will immediately Update all Calculated Controls on a Form. It applies only to a Form, so individual Controls cannot be Recalculated.

[deewe]

@ADezii
Thanks for the highlight!

I guess it's the same for the Requery Method then.

[yarbrough40]

try it without "!" and use "."

Me.Txtbox_RatioDev2.Requery
 

if that doesn't work.. what WILL work is retyping the formula for that control's value

Me.Txtbox_RatioDev2.Value = DLookup("[SID]", "UserTable", "[PrimKey] = 3")
 

[ADezii]

What will work is Saving the Record, then Requerying the Control:

SendKeys "+{ENTER}", True
Me![txtTest].Requery

[deewe]

@ADezii
Hello Adezii,

I tested it and it still updates all fields in the from. No big deal though.

[yarbrough40]

Again - you may have to simply send the value of the control again (see my code suggestion above) I promise it works!