Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2008
    Posts
    25

    Question Unanswered: Adding a Combo Box to an Append Query

    I have a append query where I have some fields that the operator needs to enter either Yes/No, which at the moment, the operators are keying 1 or 0.

    I also have a field that I need to have inputted correctly and therefore on the form, this relates to a combo box. However, I want to bring this to the query, so when the query is run and you are prompted for data - you choose from the combo box.

    Can anyone help me here?

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Operators are keying a 1 or a 0?

    So you want to have a combo box in a query?

    What version of Access have you got?!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jan 2008
    Posts
    25
    This is for an append query - I have one field that when running the report, I want the user, when prompted to add data, to only be able to choose from the pre-set options.

    The example is that the append query will update many records with the same information. I currently have the append query set for the user to add data for Date >, Date < and closure reason. What is happening is that we have set data for closure reason, however, due to operator keying, some enter different data, ie., close, closed, closing, to be closed etc.

    For reporting reasons, I want to streamline the data that they can add to the set data format, ie., in progress, closed, with specialist.

    Any help greatfully appreciated.

    I am currently using Access 2003.
    Last edited by MIKEWB20012000; 01-26-08 at 08:06.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Using a custom dialog box is the best way.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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