Please see the attached screen shot. I've smudged the data since it is confidential.
What I want to do is use this split form which I have opening maximized in the onopen event of the form. And in the left hand column I will turn the fields into comboboxes for certain field, not all of them. I want the user to be able to select a record from the combobox and have only the records that contain that selection to appear on the right.
Then in the footer of the form I'll need a command button to "Display All Records".
How can I do this?