Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2014
    Posts
    27

    Unanswered: Can't see added records in my search

    I have a form where you can add records to a table, it works and all the information goes into the table correctly but then when I use my search form the new records don't come up at all, can anyone help?

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    How does the search form works? Is it bound to the data source? If yes, do you requery it after adding a row to the table?

    You cannot expect any detailed answer with such a vague question. Please supply detailed information on how your project (or at least the concerned part of it) works.
    Have a nice day!

  3. #3
    Join Date
    Jun 2014
    Posts
    27
    Ok so my search form searches through a list of companies using different criteria such as market cap and production per day, i used text boxes for number ranges and checkboxes to correspond with yes/no fields. The search works well it returns all of the companies I want every time, except the companies I added after creating the search page, using my other form which is a form that is used purely to add and edit records in the table. I still can't figure out why it won't search them because they go into the table when I use the form, but then I cant search them.

  4. #4
    Join Date
    Jun 2014
    Posts
    27
    It is an unbound form, but the individual search fields are connected to the columns in my table, I tried copying my entire query design into a new query and then attaching the search page to that query, I can see the companies that I added, that I couldn't see before, but if i try adding companies now it won't show the newest ones and I am back to the same problem
    Last edited by MCronin; 06-25-14 at 16:31.

Posting Permissions

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