report need selected values from combo boxes in a form

[mumbaimacro]

hi

i have two combo boxes in a form with values from a table.
i need a report to be opened by a button from the form ,The Report should show the values selected in the combo boxes in the form and also i am going to show some other values from tables in the report with that.

example:
form view:

month: jan --> selected from combobox
year : 2006 --> selected from combobox


Report view :

Emp Name: mark -->Data from table employee
Emp Number: w90--> Data from table employee
Month: jan --> value selected from the combo
year 2006 -> value selected from the combo


table employee:

Emp Name , Emp Number

help me to do this.

thanks.

[PEB]

Hi,

So you have to do A query with table emplyee. This query will be the rocord source of your report

In the field of your report that is for the month in the control source you type

=Forms![MyformName]![My_Month]

and respectivly for the year:

=Forms![MyformName]![My_Year]

[mumbaimacro]

Hi,

So you have to do A query with table emplyee. This query will be the rocord source of your report

In the field of your report that is for the month in the control source you type

=Forms![MyformName]![My_Month]

and respectivly for the year:

=Forms![MyformName]![My_Year]

hi thanks for the suggestions

everything Ok now