AfterUpdate Question

[Parariddle]

Hi All

I am trying to populate a text box with a field from a query.

After updating a combo box I want the text box below to show the latest value (in this instance a date) in a query for a set field.

So Afterupdate, Textbox = Max Date in Field Next Due.

Any help would be much appreciated !

Thanks

 

[rainman89]

look up the function dmax.

You could probably use that in conjunction with a dlookup if dmax doesnt give you exactly what you need.

that should do what you want

 

[Parariddle]

Thanks Rainman

Being a noob could you perhaps give me an example of that would work.

So afterupdate text box =dmax value of a query ? I can not find how to call the value from the query in VBA ?

Thanks

 

[rainman89]

http://www.techonthenet.com/access/functions/domain/dmax.php

check that out. it should give you some ideas!