How do I move a record from a file to a report? My report displays the 1st record each time.

[StephenM]

Imade a program using Microsoft Access. Ihave many records using the auto number ID. The second field in each record isa person's name. I made a form to loadthe database and I use a combo box to pull in the record I want. Problem, when I attempt to open a report, theinformation from the 1st record always populates it. I can easily change the record displayed onthe form, but always the first record pops up on the report. I know there is some way to have the currentrecord on the form pass over to the report, but I don't know how to make thishappen. Any help would be appreciated.

[Micron]

Not much to go on there. What is the report recordsource? You would have to filter the report to whatever the autonumber id is for the current form record. Or maybe your other records are on subsequent report pages which you haven't noticed. I don't usually suggest this right at the beginning of a thread, but I suggest you copy/compact and zip your db and post here as I really think it would cut out a lot of back and forth questions. Look at the top of the forum page for "How to attach files" for help on that.

[June7]

Control used to enter/select data to filter/search should be UNBOUND, otherwise you change data in record. Since you say that part works, I assume combobox is UNBOUND.

Several ways to apply filter criteria for report. In your case, could be as simple as:

DoCmd.OpenReport "your report name here", acViewPreview, , "ID = " & Me.ID

For more info review http://allenbrowne.com/ser-62.html

[Welshgasman]

Imade a program using Microsoft Access. Ihave many records using the auto number ID. The second field in each record isa person's name. I made a form to loadthe database and I use a combo box to pull in the record I want. Problem, when I attempt to open a report, theinformation from the 1st record always populates it. I can easily change the record displayed onthe form, but always the first record pops up on the report. I know there is some way to have the currentrecord on the form pass over to the report, but I don't know how to make thishappen. Any help would be appreciated.

You do not 'move' records from a form to a report. Each looks at the records. How you tell it which ones to look at is up to you.
In your situation, you would open the report with a filter, as June7 has advised.