Passing ID's

[Trojnfn]

I have a row of records with a button and a hidden id. When I click on the button, I want to display all the detail information for that row, in a report, for each respective id.



It seems to display the first selection correctly, but when I make another selection, it does not work. The first selection is still there.

Is the id automatically passed back to the table to retrieve the rest (detail) information ? If not, how do I pass it ? The button is just a macro that opens the report (another screen has the button opening another form for editing, so I should be using the same process).

Thanks for any assistance.

[Robeen]

I have a row of records with a button and a hidden id

1. Could you explain 'row of records' please?
2. Where is this row of records? Is it on a Form?
3. What is 'a hidden id' and how is it hidden?

Could you give us more details please?

[Trojnfn]

1. Could you explain 'row of records' please?
2. Where is this row of records? Is it on a Form?
3. What is 'a hidden id' and how is it hidden?

Could you give us more details please?

I have a search form with pulldown values of cities. I select a value and then click a search button. It will then display summary data. For example, if I seach by city name New York, it will display a list of all employees in New York, for example 10 rows of names. I then click on the button to display the detail information for that employee, on a report (or on another form to edit). The id is part of the summary data but it is hidden using the properties.

[Robeen]

I seem to remember a similar issue when I was working on a Form that had a 'Continuous Form' as a Sub Form.
You opened a Customer's information on the Main Form - and then if you clicked 'Details' -> the SubForm Opened - and then if you clicked on one of the items in the SubForm - a new form opened with Editable details for the row of data that was clicked on the sub form.

In your case - I wonder if you need to include a 'Requery' command so that the previous data [on the sub form] is replaced with the new data.
Here's a link that might prove useful to you:
http://www.techonthenet.com/access/subforms/refresh.php

Let me know if this helps! All the best.