Question Filter data and show it in a report

[shamal]

Hello Masters...

When the avarage is written, universities that accept this avarage appear..
How can you report only that?
thank you....

 

[Ranman256]

if you want to report on 1 university, youd open the report:

using ID numbers:
docmd.OpenReport "rpt",acViewPreview ,,"[id]=" & me.ID

for strings:
docmd.OpenReport "rpt",acViewPreview ,,"[University]='" & me.University & "'"

 

[shamal]

Ranman256
Can you apply the code to the attached example?
Because it did not work with me

 

[shamal]

Can you apply the code to the attached example?
Because it did not work with me

 

[mike60smart]

Hi shamal

See the attached.

I recreated the Form.
Added a Combobox to allow the user to select the Average.
When you click the Command Button it Opens the filtered Report.

View attachment Universities.zip