How to lookup last record id and take value from another field of that record

[bruceblack]

Hi everyone! Some basics that i cant seem to find if its out there.
Ive been searching but cant find it. Maybe someone can explain?


I have a table with an "ID" field and a "COUNTRY" field.

How can i get the highest ID, and get the value thats in COUNTRY of that record?

I would like this in VBA, not a query builder

 

[Gasman]

Dmax for the ID and then Dlookup for the Country. ?

Combine them even, in the Dloookup perhaps.?

 

[bruceblack]

Ah thanks gasman

I looked up combining them. Got it to work.

Final code:

stringname = DLookup("NumberNeeded", "table1", "[ID] = DMax('[ID]','table1')")

Thanks!!!!!

 

[Gasman]

Interesting.
I would have gone with

stringname = DLookup("NumberNeeded", "table1", "[ID] = " & DMax("ID","table1"))

but as long as it works, that is the main thing.