Results 1 to 3 of 3
  1. #1
    wmc326 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2017
    Posts
    3

    Form loads as if I have typed into the search query

    Hi all,



    The title is self explanatory of my problem... I've been working on a access database for my company, I first used some short fake names and information to ensure all functions and code was working properly. Today, I went to replace and log all of the real information of the employees, and all of the sudden the search query automatically loads as if I've typed something into the search bar upon the form opening.

    To explain better, there is 57 employees in this database, and it automatically loads as if you have searched for employee 36. I was not having this problem prior to replacing the pseudo information, as all 57 fields were loading on form open. The form and search query still works normally, it is just loading on that specific employee that I am having trouble with. I have not tampered with my code at all, or even gotten into design view. I must of accidentally activated something, somehow, but I'm not sure what it could be.

    Any and all help is welcome, thanks in advance!!

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,741
    Take a look at the form's recordsource query. I'll bet it has a hardcoded employee 36.

  3. #3
    wmc326 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2017
    Posts
    3
    That was it! Thank you so much!

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

Similar Threads

  1. Replies: 4
    Last Post: 05-01-2017, 11:32 AM
  2. Search List results as data is typed
    By smpk42 in forum Programming
    Replies: 1
    Last Post: 03-11-2016, 11:28 AM
  3. Form loads with no current record
    By ts_hunter in forum Forms
    Replies: 11
    Last Post: 01-15-2014, 10:33 AM
  4. Form loads blank
    By sweetiepie in forum Forms
    Replies: 5
    Last Post: 06-07-2012, 02:34 PM
  5. list box not updating until form loads
    By cowboy in forum Forms
    Replies: 3
    Last Post: 03-12-2010, 12:02 PM

Tags for this Thread

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