I have a main form with a number of fields bound to a table. On the form is a search button in which gives me the ability to search for records in the table that is bound to my main form. When I click on the search button it pops up another small form which allows the user to search on the particular fields. When they click enter it searches the table. The results of the search are displayed in a cursor at the moment. What I want to do is allow the user to select a record in the cursor and then when they press enter it shows all the information from that record back in my main form. This is rather than scrolling through records using nav buttons.

I am starting to think that I shouldn't use a cursor. Any ideas?

Many Thanks