>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
Why not have all the records in a grid, in a paged form. Select the rec in the grid (you can still have your search button but it doesn't create a cursor), then turn to the details page.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.