Only One Record On Report (1 Viewer)

[musclecarlover07]

I have a report that has all the information I need from several Data sheets. Is there a way I can have the report show only one record instead of all. I would liek for the report to have a field where I type the Primary Key and then it does a search and displays the one result. The reason for this is I need to upload the report into a record managment system per person. If any more inforation is needed please let me know.

 

[musclecarlover07]

I'm sorry but Im lost. Im new to dealing with reports.

 

[musclecarlover07]

Ok so I got the combo box. What code should I have for the report? I need for the report to pull a couple fields from multiple datasheets. Exampl one datsheet with have the person's info another datasheet will have carrier inforamtion.

 

[musclecarlover07]

I used the report wizard and did all that. But it shows all records. I just one record to show an only one. Right now I have to use Snippet to take a screen shot of just the record I want. I just need for one record to populate an thats the one I designate. So every time i change the primary key the info updates to the info from the one primary key.

 

[musclecarlover07]

I read the 2 thread but it doesnt make much sense. I get creating the form an using a drop down box to selct the primary key. The code an button to run the report is where im lost. If i create a report with the info I need it always creates reports for ALL records. I need for one record, the one i choose, to be shown an the only one. For this report gets saved an filed an emailed an so on.

 

[musclecarlover07]

Ok I do not know what the "where" argument is. I tried looking it up but it wasnt very succesfull.

 

[pbaldy]

See if this helps:

http://www.baldyweb.com/wherecondition.htm

OpenReport can use the same method, which is the argument Pat is referring to.