Records-selected

[am_sarath]

Hello

I have a combox box which lists(TOP25, TOP15, TOP10 and TOP5)in a form .when i select TOP10, and click on view the report, i should get the reocrds associated with TOP10.similarly it should hold the same with the other selection.

I have a designed a report and i am able to view the records in my report ir-respective of the selection in my combo.what ever i select, it shows the same record every time.
the records are fetch from 5 tables which in turn have relation between each other.could any body help me to solve my problem.any query or coding would be appreciable.

Thank you

 

[Chris RR]

What are "TOP25", "TOP15", etc? Are they tables, queries, or are you trying to do an Access "top values" query?

Can I assume that you are running one report, based upon one query, and that query references the content of your combobox?

 

[am_sarath]

TOP25,TOP10 are the values listed in my combo box.This field is called rank in my table and based on the selection, i should be able to retrieve the records.I have'nt written any query.could you please help me out.

Thanking you in advance.