Macro writing

[Rizwan Amin]

I want to write a macro which will open a dailog box and ask for search parameters, these parameters belong to different tables of a database which possesses data of an Human Resource Department, after asking for parameters the macro should create a report which displays the matching results.

 

[Smilie]

The "dialog box" will actually just be a form with an unbound combo box for each of the different parameters for the report. Create a query that has a all the fields on the table with a condition that it equals the value of the corresponding combobox.

After the user selects the parameters they want they will click on a button with a macro that will run a macro that opens the report with the query as the filter.

Hope that makes sense!