Im trying to implement a function in Access 2003 to allow the application to find a given field from a give another field in the same record. e.g.

I have a table of Assets called tblAssets, im trying to write a function that returns the AssetLabel from inputing the AssetID etc. The problem is i want to be able to find any record field based on another field inputed as a paramater and also allow other tables to be accessed.

Public Function WhatIs(FindPar As Variant, FromField As Field, ResultPar As Variant, ResultField As Field, rst As Recordset)

Set rstUnique = db.OpenRecordset(rst, dbOpenDynaset)

With rstUnique
.MoveFirst
Do

If FromField = FindPar Then
ResultPar = ResultField
End If

.MoveNext

Loop Until .EOF

End With

End Function

The function would be :-

WhatIs("Pc1", Field.AssetLabel, x, Field.AssetID, "tblAssets")

But this doesnt work argh.

Is this the right approach or is there a better way to define a dynamic function.

To succeed is to fail at least once.

The parameter you pass as "rst" should not be an actual recordset object, but rather a string, because the database.OpenRecodset method, takes in the Recordset name as a string.

You can argue, fight and quarrel all you want, but at the end of the day you will have a headache