Drop down list not displaying

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Rosy
    #1

    Drop down list not displaying

    I have a database shared across a network. On all terminals except
    one, the database performs perfectly. The one oddball machine won't
    display drop down lists. The list opens but is empty. I am unable to
    "filter" by any field that has a drop down. I first verified that
    this machine was linking to the actual database. I then opened the
    database from it's origin with the same issue occurring. I have
    deleted and recreated the drop down, rebooted, run microsoft updates,
    uninstalled and reinstalled office suite. I don't know what else to
    try. Has anyone else ever had this problem?

    Tags: None
    • Salad
      #2
      Re: Drop down list not displaying

      Rosy wrote:
      I have a database shared across a network. On all terminals except
      one, the database performs perfectly. The one oddball machine won't
      display drop down lists. The list opens but is empty. I am unable to
      "filter" by any field that has a drop down. I first verified that
      this machine was linking to the actual database. I then opened the
      database from it's origin with the same issue occurring. I have
      deleted and recreated the drop down, rebooted, run microsoft updates,
      uninstalled and reinstalled office suite. I don't know what else to
      try. Has anyone else ever had this problem?
      >
      I haven't. Does the user use a copy of Access? If so, why not open the
      front end...or create a new database. Then go to Forms/New/Design and
      create a dropdown, save and run. You should be able to get the
      ListCount value...in the GotFocus event enter something like
      msgbox Me.ComboboxName .ListCount
      The listcount may have 1 added to it if you have column headings on.

      It's quite possible something is goofy. You could enter stuff like
      msgbox Me.ComboboxName .RowSource
      to see what the current rowsource is.

      It's possible there really aren't any rows and columns to display.

        Comment

        • Ken Snell
          #3
          Re: Drop down list not displaying

          By chance, did that PC get upgraded to SP3 for Office 2003? There is a bug
          that sounds similar to what you're seeing....

          --

          Ken Snell
          <MS ACCESS MVP>


          "Rosy" <krmoss@portlit e.comwrote in message
          news:1190928055 .050570.33770@r 29g2000hsg.goog legroups.com...
          >I have a database shared across a network. On all terminals except
          one, the database performs perfectly. The one oddball machine won't
          display drop down lists. The list opens but is empty. I am unable to
          "filter" by any field that has a drop down. I first verified that
          this machine was linking to the actual database. I then opened the
          database from it's origin with the same issue occurring. I have
          deleted and recreated the drop down, rebooted, run microsoft updates,
          uninstalled and reinstalled office suite. I don't know what else to
          try. Has anyone else ever had this problem?
          >

            Comment

            Previous template Next
            Working...