• Listbox default value (Access 2003)

    Author
    Topic
    #442797

    The following line of code sets the default value of a list box on an unbound editing form. This form should show the existing data for a record so that the user can change it and resave or cancel.

    Forms!frmTransactionEdit!lstSelectCategory.DefaultValue = rs!TransactionCategoryID

    Whilst this code works insofar as it correctly sets the default, it doesn’t highlight the line in the list box, therefore the user can’t see what the current value is. How can I make the highlight show?

    David

    Viewing 0 reply threads
    Author
    Replies
    • #1066806

      I’d set the Value property instead of the DefaultValue property.

    Viewing 0 reply threads
    Reply To: Listbox default value (Access 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: