I have tried everything, what am I doing wrong?
I have a data entry form in datasheet view (for mass data entry). One of the
fields are SalesID, and I would like to use DLookup to populate an unbound
field next to it, just for information for the data entry person.
I use:
strFilter = "SalesRefID = " & Me!Salesid
Me!Salesnavn = DLookup("SalesName", "SalesIDs", strFilter)
This works fine, but it populates every record in the datasheet with the
same name. How do I address one explicit row in my datasheet?