Sending the ID for indiviual row to another form

[The]

I made a report that sort all my data, next to each individual row there is Edit button.
For the OnClick Event for the button I used OpenForm from the Macro Builder to open my editing form. Now I am trying to send the unique ID for that specific row to the next form. I could not do that using the Where Condition filed. Each time I click the edit form, it popup a dialog asks my to enter the id.



How can I properly send the ID to the new form, and use it there?

Thanks for your help

[June7]

You mean you made a form to sort data and button is on form?

Why do you need to 'send' the ID? Are you creating a new record? Or do you just need to filter the form?

[The]

You mean you made a form to sort data and button is on form?

Why do you need to 'send' the ID? Are you creating a new record? Or do you just need to filter the form?

No sir

I made a report just to view all records in a certain order. Next to each record, and there is an update button. The update button take you to the editing form.

[June7]

Buttons won't work in report PrintPreview mode.

I don't know why you get input popup. If you want to provide db for analysis, follow instructions at bottom of my post.

[The]

Thanks for the important information.

About my question, I solved it using:

DoCmd.OpenForm "Edit_Unit", , , "U_ID=" & Me.U_ID

I thought report the only way to sort the data under category!!