• Problem combo box (2003)

    Author
    Topic
    #457108

    Hi All,

    Does anyone know why my combo box is not doing as I expected. I have a form which was created a few weeks ago, and have now decided to add a combo box to this form, the combo box uses the row Source property to read the data from a table the field name in the table is called ‘user_code’

    When viewing the query in view mode I can see the data I expected however when I save the form and open it in normal mode the drop down display the right amount of rows but I cannot see any text.

    The combo is not bound to anything, I was going to use the after update event to filter the other data on the form.

    Thanks

    UPDATE: I have noticed if I add more than one column to the row source i.e. User_code and Name and set the bound coloumn to 1 (user_code) and column count to two if I click the combo the dropdown will display blank under user_code but I can see the names in the name column when I select one nothing gets displayed in the combo box the value is null

    Viewing 0 reply threads
    Author
    Replies
    • #1144957

      Could you post a stripped down copy of your database? See post 401925 for instructions.

      BTW was the reply to post 755,844 helpful?

      • #1144960

        Thanks Hans, I will do. And yes it was helpfull I have only just had time to test it out but works gret now many thanks. Have replied on the original post now!

        • #1145343

          Thanks

          Heres part one of the striped down database

          • #1145344

            Hi,

            Heres part two this is the backend with the data.

            The form is in the first download and called frm_Dashboard_IA I have highlighted the problem combo in red

            Thanks

    Viewing 0 reply threads
    Reply To: Problem combo box (2003)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: