Create a form to enter report criteria?

[Louly]

Create a form to enter report criteria? Anyone can help me with this?
I don't want to do it using the Macros method. Is there a way to do it
using VBA?

Thanks for your cooperation.

Louly

[BillCo]

It's very do-able. What you need to do is build up a SQL statment in
code and pass open the report with this statemtent as a where criteria.
eg have a form with a control txtName on it
the user types the name criteria (complete with any wildcards) and
clicks the view report button on your form.
this runs the following air code:

function button_click()
'passes the selected name as a where condition to report rptNames
Dim strSQL as string
strSQL = "[tblNames].[Name] like '" & me.txtName & "'"
DoCmd.OpenReport "rptNames", , , strSQL
End function

You can of course add more controls and make the SQL condition
statement as detailed as you like. You will probably need to learn a
bit more about SQL syntax and string manipulation though.

Hope this helps :)