Customizing reports - Help urgent

  • Thread starter Thread starter Raj
  • Start date Start date
R

Raj

Dear ALL,

I am trying to build a custom report for an access database. i have a combo
box with values of all the employees. when a user selects an employee from
the combo box, i want a report to be generated from a table or query ABC
which will
display all the records which tally with the employee name.
Any help is highly appreciated.
Based on this, I have to create more reports and conditions which I believe
i could with all ur help and support.

Thank you.
Raj.
 
Please DO NOT post duplicate questions in more than one group.

It wastes people's time if they answer your issue then find someone else has
already answered in another group. If you are unsure where to post, you can
post ONE question to multiple groups by entering them in the "Newsgroups:"
field when you post. Then, any answers will appear in all the groups so
others will be aware of previous answers.
 
Set the report's Filter property to the value of your combo box:
=Forms!MyFormName!MyComboBoxName
 
I guess my question was wrong or am not understanding.
I wanted to build from a custom query for an access database. i have a
combo box with values of all the employees. when a user selects an employee
from the combo box, i want a report/query to be generated from a query ABC
which will display all the records which tally with the employee name.
Any help is highly appreciated.
Based on this, I have to create more reports and conditions which I believe
i could with all ur help and support.

Thank you.
Raj.
 
Put the code in the combobox's AfterUpdate event, then.

You can retrieve the employee's name from the combobox, and use it to set
the strWhere that Allen shows in the URL he cited, then use OpenReport,
passing it strWhere.
 
Back
Top