Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    default shown on combo box (Access 2000)

    I have a combo box that is built on a sql statement on a form. I would like to know if there is a way that I can show the default entry (say USA) on this combo box when the form is loaded.

    Thank

  2. #2
    Star Lounger
    Join Date
    Sep 2002
    Location
    New York, New York
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: default shown on combo box (Access 2000)

    On the property sheet for the combo box, click on the Data tab. You'll see a Default Value property field. This is a value that will automatically be loaded each time the form is loaded. Just enter the value you want here.

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: default shown on combo box (Access 2000)

    Thanks.

    What about if I have multiple combo boxes and if I make a selection on a calendar, these boxes will retrieve the data from a table and display the corresponding entries?

    thanks

  4. #4
    Star Lounger
    Join Date
    Sep 2002
    Location
    New York, New York
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: default shown on combo box (Access 2000)

    I'm afraid I don't quite understand what you're asking. How does the selection on the calendar (and which calendar?) effect these combo boxes? Let me say this, however: the default value is set independently for each combo box on a form, and the default value is loaded into the form when the form/record is opened. If you want to change the value of combobox based on other selections on the form you need to look into VB coding. Hope this helps.

    -Karl

Posting Permissions

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