Kan dette overhovedet lade sig gøre

DLookup("[Shipname]", "master", "[Shipname]='" & Me.Shipname & "'")

'mugs' For debug error på Me.

Nu ved jeg ikke hvilke data du vil hente. Brugte Me.Shipname fordi jeg synes det var indlysende. Shipname skal være et felt i din formular.

shipname = DFirst("[shipname]","[master]")
As far as I can see you only have one

If you have more than one then you need to include something in the WHERE clause (last paramater)

Then you could do sómething like this

Function shipname(SomeKey as String)
shipname = DLookUp("[shipname]","[master]","SomeField = " & SomeKey & "'")

Then you would call the function

TheName = ShipName( me.somevalue )

End Function

Hvad skulle jeg gøre uden 'terry' og 'mugs'?

:o)