How do I do an Excel's indirect function in Access?

[ShaneBrennan]

This is not easy to explain but I wish to extract information from a table, using a variable which holds the name of the field I wish to extract information from.

For example if I want to extract information from the Field StudentID I can use the following line:

Label3.Caption = rst![StudentID]

If I have a variable called FldName which = "StudentID" is there someway of producing a line of code similar to the following:

Label3.caption = indirect("rst![",FldName,"]&quot

Thanks for any help

Shane Brennan - Learning access - but very slowly!

Shane Brennan
Shane.Brennan@tcat.ac.uk

 

[MissyEd]

Try this:

Label3.Caption = rst(fldname)
where fldname is the name of the field in string form e.g. "StudentID"

Missy Ed
Looking to exchange ideas and tips on VB and MS Access development as well as office 97 development. Drop me a line: msedbbw@hotmail.com