Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2012
    Posts
    88

    Unanswered: Select drop-down

    Hi All

    Could you perhaps help me with the following.

    I have a drop-down list.

    Lets say the drop-down lists name is Drop and the selection choices are:
    A
    B
    C

    Lets say I have 1000 records and all are selected for B, now I want to change all with the selection C. Is this possible? I do not want to click a 1000 times.

    Regards
    Hennie

  2. #2
    Join Date
    Apr 2013
    Posts
    226
    You could do this with a query to get all the Bs and then set it to execute a script for each record. The script would change this field value to C.

    Matty

  3. #3
    Join Date
    Sep 2012
    Posts
    88
    Hi Matty

    That's true but it only the display C, what I mean is that the query must select C. Specially if you have other functions base on the selection of the drop-down.
    Hennie

  4. #4
    Join Date
    Apr 2013
    Posts
    226
    You execute a script for each record (an option in the query setup) to change the dropdown value to C.

  5. #5
    Join Date
    Jun 2012
    Posts
    163
    Provided Answers: 1
    maybe out of topic, but... for experience... when you have a dropdown combo, in order to avoid scripting error, your first option should be "blank space"
    like this:

    A
    B
    B
    (please note that the first space is empty)

  6. #6
    Join Date
    Dec 2012
    Location
    Huntsville, AL
    Posts
    379
    Provided Answers: 2
    fers,
    You should put that valuable piece of information on the 'best practices' thread. I had an issue several months back and that was exactly what was causing it... I had no idea that it made any difference until I started having some strange problems.
    Daryl G

  7. #7
    Join Date
    Jun 2012
    Posts
    163
    Provided Answers: 1
    i will my dear daryl

Posting Permissions

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