Go to Record

[jfoosh]

Hi All,

I have created a DB for displaying outstanding issues. Basically, there is a search form for users to search by certain criteria. Once, a user selects the "Search" button the results are displayed in a subform. Next to each result is an option to open a specific issue in another form for more details which is done by a Macro. Here is the problem: Say 3 results come up 1, 2 & 3. If you want to see the details for issue 3, it always pulls up the first record which is 1. How can I get the Macro to go to the record selected based.

Thanks

 

[Sum Guy]

Try using a new query with the selection on the form as the criteria.

 

[Mike375]

You have a macro action GoToRecord which has first, last, next, previous, new.

You can also include in the macro a GoToControl and then a sort on the selected field and then GoToRecord.

Then as Sum Guy said you have a parameter query. You also have Where at the bottom of the OpenForm action.