too many results!

[jarheadjim]

I have placed a command button on a form to open a report, but rather than show me just the information on that form, it gives me every record on the table. How do I make it just show the current information?

thanks

 

[Travis]

When you do the Open Report code pass a Where condition with it to limit the report.

Example:

DoCmd.OpenReport "Report Name", acViewPreview, , "[MyID]=" & Me.[IDField]

 

[jarheadjim]

I'm afraid I don't understand, what is [myid] in the example? Wouldn't this prompt you for input?

 

[jarheadjim]

let me see if i have this. I have it using an autonumber to be the primary key. this field is called [ReqNum]. so [myid]=[ReqNum], but what does [idfield]= ?, the name of the form that contains the field in question? sorry, i'm just not overly familiar with the lingo of database's. thanks for the help so far.

 

[Travis]

let me see if i have this. I have it using an autonumber to be the primary key. this field is called [ReqNum]. so [myid]=[ReqNum], but what does [idfield]= ?, the name of the form that contains the field in question? sorry, i'm just not overly familiar with the lingo of database's. thanks for the help so far.

[MyId] = the Field Name in the Query/Table
[Idfield] =[The Name of the Field with the ReqNum Value in it]
Me = the Current form that the code is on. It is a substitute for "Forms![Your Form Name]"

DoCmd.OpenReport "Report Name", acViewPreview, , "[ReqNum]=" & Me.[The Name of the Field with the ReqNum Value in it]

 

[jarheadjim]

YAY

Got it! I think what was throwing me off was that [myid] & [idfield] happen to be the exact same thing in my case. It works fine now. Thank you all for your patience.