Removing QuickSearch broke my form

I have a single record form, built to my USER table, that was working correctly. It is for an individual user profile, so, I need to restrict the form to accessing only 1 record… the record of the currently logged in user. I tried to do this by going into the form’s ToolBar settings and removing the quick search and all navivation buttons. The only button that should appear should be the “Save” button. However what happens now is… when I run the form, instead of seeing the form with data (like it used to), I am now presented with a tiny text box, with the title of my primary key field, and a button captioned with the name of my form. If I enter a valid primary key, the form, with correct data, will be presented. If I don’t, the form will be empty. I suppose this will work as long as I call the form from another form, and include the primary key as a parameter.

HOWEVER… just for the sake of learning… let’s pretend I want to switch this form back to operating like it did before… with multiple records available via navigation… I am unable to do that. No matter what ToolBar buttons I put back, the form always displays the primary search key text box upon start up. How do I change the form back, so that it works like it did in the default mode, where other records where accessible from the ToolBar navigation buttons?

Re: Removing QuickSearch broke my form

On login define a golbal or session variable with the user_id.
Then you have to adjust your sql statement by adding a “where” clause.
In the Form Settings click on SQL and add your filter for the current user in the field “Where Condition” .
i.e. user_id = [global_user_id]

That should do it.