How do you generically reference fields in VBA?

[bghedtodd]

Thanks in advance for your help!

I have a loop that assigns the name of a table to the variable "a" I want to use a sequel statement to access the contents of this table and have it ordered according to the first field before several other actions are performed. What is the best way to do this?

This is what I am trying, but am not sure if this is technically correct:

strSQL = "SELECT * FROM [" & a & "] ORDER BY 'Fields(0)' ASC"

[pod]

looks ok to me ... try it and let us know

you can also make use of a SELECT/CASE for specific tables and fields

SELECT CASE a
   CASE "projectTBL"
      FLD = "projectNumber"
   CASE "ClientTBL"
      FLD = "ClientName"
   CASE ELSE
      ... 
END SELECT
strSQL = "SELECT * FROM [" & a & "] ORDER BY " & FLD  & " ASC"
 

[bghedtodd]

Thanks POD -- clever trick with the case selection for FLD!

[pod]

You are welcome BG

Bytes is full of clever tricks and members

P;oD