Getting No Current Record warning after a form loads

Tjs_111656 1 Reputation point
2022-05-11T19:28:12.157+00:00

I have a search form where the user enters client criteria clicks the search bottom and returns all clients that match criteria. They can scroll through the results and click a select button that allows them to display the client form with the complete client information for the selected client. Two days ago, when they would click the select button, the form would open and display the correct information however there is a warning pop up No Current Record. They have to click OK to get rid of it. The select button has code, on the On Click event, that uses the information on the search form to open the client form and set a record source for the client form and closes the search form. When I step through the code the warning appears after the End Sub. I have tried compacting and repairing the data base.. Creating a new Client table using the Create Table Design, typing in the fields exactly as they are in the original table and entering a record that table, re writing the code for the On Click event, nothing has worked. Any Ideas how to get rid of the warning would be greatly appreciated.

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
891 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Tom van Stiphout 1,696 Reputation points MVP
    2022-05-11T22:21:30.723+00:00

    MSFT just fixed this. Close and reopen Access and try again.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.