Hi all,
I could use a little help using DLookup function where it places a numeric result of 2 queries (though I think I can get the same result with just using 1) in an unbound text box on a continuous form.
By placing
in the control source for the text box I get the correct the result, but it is placing the same number in every record. What I am trying to achieve is an increment of 1 in each records text box.Code:=DLookUp(" MaxOfPart_Number","qryIncrementPart_Number")
Any pointers?