Hi,
I am getting an #Name? error when i try the following dmax code,
am i doing it wrong?
=DMax("[VolumeID]","[tblOTCVolume]","[OTCID] = " & [otcid])
thanks

Your expression looks fine. Is [otcid] a control on the form you're using the expression and is it a numerical value?

hi , OTCid is a bound text box on my form where the code is and it is a number , does that change things?

Are you using the code directly in the control source of an unbound textbox? Is there a possibility that [otcid] could be Null. Are you sure that the fields VolumeID and OTCID exist in tblOTCVolume and all names are spelt correctly? I'm sure you've checked all these things already, just going over the obvious really.............

Hi
Also try: