In the attached sample DB I have a table, with "Ullage" and "M3" fields.
If I on a form use below code on textboxes, I can get the volume in M3, if I type in the Ullage.
Example code:
Me.txtVolumeM3 = Nz(DLookup("M3", "tblUllage", "Ullage='" & Me.txtUllage & "'"))
The issue I have is for each...