MS Access "#Name?" in unbound field on SOME machines
- by alkorya
I have a datasheet form bound to table. I added 2 unbound fields and set their Control Source properties to user defined VBA functions:
1. ConcatRelated (http://allenbrowne.com/func-concat.html)
2. Custom function that returns a string:
Public Function GetLowestSatatus(LookupField As String, JSAID As Integer) As String
On Error Resume Next
GetLowestSatatus = DLookup(LookupField, "JsaStatuses", "ID=" & DMin("StatusID", "Tasks", "JSAID =" & JSAID))
End Function
It works fine on my and some other machines but there are machines I got "#Name?" in these 2 unbound fields. All machines configured identically.
Any ideas?
Thank you!
