Needed an expression in a FORM to pick info from other table based on a condition

[amanthethi]

Hi there,

I have a form in which I have X,Y,Z Fields/Co-ordinates coming from a Table named "A" .

Also I have a field called "ID" in this form which can be either 0 or a number.

I want an expression in X,Y,Z to pick info from other field PQR from another Table named "B" when ID=0.



Please and Thanks

[Micron]

= DLookup("PQR", "B","ID=0") ?

EDIT - table B only has one record with ID of 0 and perhaps one record with ID of any particular number? If not, then DLookup will return a random record.