Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: Evaluate Field Names

    I have a table of field names (tblFieldNames) with a field named [strFieldName] and want to look up the data in a second table (tblNames) using the field name from the tblFieldName table.
    something like:
    So: strFieldName from tblFieldNames has a content value of "[strName]" (with or without the brackets - I'm easy here)
    I then want to evaluate the content of [strFieldName] from table tblFieldNames looking it up in tblNames.
    Hopefully my question makes sense??? If not I will try some more examples.
    Any one got any ideas?

  2. #2
    Join Date
    Apr 2004
    Solved it using DBLookup

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts