Results 1 to 4 of 4
  1. #1
    dj7wilson is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Apr 2021
    Posts
    2

    Form is bound and saves but does not retrieve records


    I have a tabbed form. It is just long, but not complicated; no subforms, no unbound fields, almost all text boxes. When I fill the form in, it saves to the bound table just fine. However, it will not retrieve the records. The standard navigation buttons at the bottom don't work and always read 1 of 1 (even though I have 10 rows of test data in the table). When I try to search, I get a popup that reads "you can't use find or replace now; the fields are not searchable due to one of the following: The fields are controls (such as buttons or OLE objects; The fields have no data; There are no fields to search. I'm stumped!

  2. #2
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,404
    Check and see if form property DataEntry=Yes. Change it to NO.

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,778
    You are referring to a form with a tab control on it, or it is a form in tab view?
    Perhaps you have set this to open with Data Entry set to yes? If so, change to No.
    Or you're setting a filter at some point that only returns one record. If you really get stumped, copy your db, compact & zip the copy and post it here for analysis.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    dj7wilson is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Apr 2021
    Posts
    2
    Oh Lordy! How did I not see that! Thank you!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Closing form with code, still saves changes
    By Perceptus in forum Programming
    Replies: 5
    Last Post: 06-03-2020, 03:11 PM
  2. Replies: 1
    Last Post: 06-20-2019, 03:35 PM
  3. Replies: 2
    Last Post: 05-30-2018, 10:43 AM
  4. Replies: 2
    Last Post: 06-08-2015, 02:56 PM
  5. Replies: 1
    Last Post: 07-29-2014, 04:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums