Filter Report Results with VBA

[Treisio]

Hello all, Access newbie here.

I have a report containing all the fields from my "main table". I want to create buttons on a from that will filter information from the report. For instance, I have a field titled "Priority". I want to create a button that will filter the report to only show records with a "Level 1" priority. Is there anyway I can do this using VBA?

Thanks in advance

 

[rzw0wr]

Yes, I would use the docmd.OpenReport "YourReportName",,"Your specific Criteria Here"

Post back if you have further questions.

Dale

 

[Treisio]

What do you mean by "Your Specific Criteria Here"?

 

[rzw0wr]

For instance, I have a field titled "Priority". I want to create a button that will filter the report to only show records with a "Level 1" priority.

Whatever data makes the report equine. Like a customer ID.

Since you have not given any data information I can only answer in general terms.

Dale