General discussion

  • Creator
    Topic
  • #2073627

    Need to set value for a field in a query

    Locked

    by cynder ·

    I neeneed to be able to set the value for the field in a query. I want the user of the program to be able to choose the field he wants to search through a combo box.

    WHERE [tblBugs].[=[frmBugEntry]![FieldList]] = [frmBugEntry]![TextSearch]

    The above code was taken form the Accesss2k SQL view of the query. I am at a comlete loss here so any help you can provide for the few points I have offered would be appreciated.

All Comments

  • Author
    Replies
    • #3893463

      Need to set value for a field in a query

      by wessir ·

      In reply to Need to set value for a field in a query

      In Access Query design window (QBE Grid) you can get parameters from the user by entering brackets around your question [Enter variable?] and putting it on the “criteria” line. Whenever access encounters the brackets [] and doesn’t recognize the variable it prompts the user for it. If you want to change the actual field that is being searched rather than the criteria used, you must modify the QueryDef object at run time using visual basic. (far more difficult but possible)

      • #3893456

        Need to set value for a field in a query

        by cynder ·

        In reply to Need to set value for a field in a query

        If you could go into further detail on the QueryDef object alterations that I amy need to make then you could end up with all the points, I already nkow about the [] braces.

        -cynder

Viewing 0 reply threads