Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jun 2002
    Location
    Nottingham, Nottinghamshire, United Kingdom
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Listbox default value (Access 2003)

    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.Default Value = 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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Listbox default value (Access 2003)

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

Posting Permissions

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