Opening Form Problem

[jax]

I need some help!! I have a form which has a "search button" where users can look to see if a person is already entered on the database. The search button opens another "search form" which consists of a combo box at the top and a list of all people already on the database below.
When a surname is entered or chosen from the combo box the first person with that surname is highlighted. If the user then wants to see the information held on that person they double click on the listed surname and another form opens at their particular record. So far so good.
The problem I am having is although the form opens at the correct record all other records are no longer available. How do I get the form to open at the right record but still be able to navigate through all records in the database using the navigation buttons?
I hope this makes sense - any help would be appreciated.

 

[Mile-O]

First: why would you want to do this?

Opening a form to a specific record and eliminating all others is best practice as it increases the speed of your database.


Secondly, your problem is that you are opening a form with criteria. This criteria filters to the record you request, eliminating all others.

If you need to have all records then you can open the form on the first record in the underlying recordset and use a bookmark to locate the record you wish.

 

[jax]

Thanks for your help.

In response to your "Why" question - its because I have been told thats what the users want ;-(

How do I use Bookmark to open another form at a particular record when a field is clicked?

 

[Pat Hartman]

Rather than just using the the id of the selected record, you could use the same filter that is being applied to the current form. That will open the popup with the same recordset as the base form. You would need to pass the id of the selected record in the OpenArgs argument so that when the pop up form opens it can position itself on the specific selected record.