Reports everything from table not just current entry

[Mix_Silence]

I know very little about Access but my work says that I need to create this database or get cut to casual time. I cannot afford the cut in pay and so I am muddling through trying to create this database for my company. So here is one of my problems...

In a form I have a contact summary for each of my visits to a client but when I go to the report to print this it wants to print out all the entries from the table where the information is stored and not just the current information. I need to find a way for only the current info to print out and it needs to be easy for my even less computer literate co-workers.

I am not working in SQL and no nothing about codes and such... just working strictly in Access. HELP ME PLEASE!!!!

Thanks in advance,
Mix

 

[Rich]

Use the Where clause of the OpenReport method

 

[Mix_Silence]

um, I am sure I sound really dumb when I ask this but ... huh? I don't know what you are talking about... can you tell me step by step what you mean.

 

[boblarson]

DoCmd.OpenReport "YourReportNameHere", acPreview, ,"[YourIDNumberHere]=" & Me.YourControlNameWhichHousesTheIDhere

Replace YourReportNameHere with the actual name of your report,
Replace YourIDNumberHere with the actual name of the Primary Key that identifies your unique record,
Replace YourControlNameWhichHousesTheIDhere with the actual name of the control (combo box, text box, etc.) that has the ID which it needs to find.