Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006
    Posts
    2

    Unanswered: Missing records in drop down list box

    Hello,
    I have a data access page that uses a drop down list box to retrieve records from a query. The problem I am having is that the query returns 450 records, but the list box on the DAP is only listing the first 300.

    I have a form that does the same thing as the DAP (for people here who have access) and it works fine, listing all the records.

    I'm not sure what other info to include here to explain the problem better, hopefully someone can steer me in the right direction.

    Thanks,
    Tym

  2. #2
    Join Date
    Jul 2005
    Posts
    50
    And you have no filters on the Listbox data? You double-checked that?

  3. #3
    Join Date
    Apr 2006
    Posts
    2
    Quote Originally Posted by mlbuie
    And you have no filters on the Listbox data? You double-checked that?
    Nope, no filters. I put in the drop-down box with the wizard, choosing the option to look up values from a query. Basically the same thing I did with the Form that I also made off the same query, except the control on the form works fine and the data access page doesn't....

    Now, having said that, I'm a mfg. engineer, not a db guy (wish I had one!) and I know I didn't put a filter on it intentionally, but truthfully I haven't used a filter on anything so I'm not sure how I'd check.

    Tym

Posting Permissions

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