Show empty form until valid search is executed

[joe789]

Hey Folks,

Got a question: I created an access form with a subform inside of it, the form opens automatically once the access database is opened ... everything works just fine. However, obviously the very first record in the dataset is returned and displayed on the screen once the form is displayed. I do not want any record to be displayed on the form unless the user performs a search using a combobox I have installed on the form; until that time, I want no data shown for any record, and that includes the first record in the dataset being shown. If the user enters the unique ID in the combobox and hits it and such ID exists, the form goes to display that record properly in the main form and subform within that main form; but until the user enter a valid ID that is found in the dataset, I want nothing shown on the form. Also, I should note this dataset and form is not editable, this isn't for a user to enter data into, it simply uses several linked ODBC SQL tables and is meant to display already existing data, the user cannot enter anything, only display via ID. Is this easily possible? I would appreciate any help I can get, this is for a nonprofit government agency.

Thank you very much,

Joe

 

[dkinley]

A quick fix is to use an unbound form with some leading information like a startup form. Place your combo box on this form.

Since all you are doing is filtering you will probably only be showing one record at a time.

Once they make a selection, it opens up the data-bound form to display said record. Once they are done reading, they can hit a command button that closes that form and are returned to the startup form.

-dK