Freddie,
Are you trying to produce a report that limits data to the ShipName and CompleteDate entered by the user? If so then there are at least 2 ways:
1. Make a cursor which contains just the data for the report, then run the report as Sylvain said.
SELECT * from MyTable where ShipName = thisform.txtShipName.value AND CompleteDate = thisformlCompleteDate.value into cursor RptCursor
Report Form MyReport && Report uses RptCursor for its data
2. Use the "FOR" clause in the Report command:
SELECT MyTable
Report Form MyReport for ShipName = thisform.txtShipName.value AND CompleteDate = thisformlCompleteDate.value
My preference is STRONGLY for method (1). With a cursor you have a snapshot of the data, you can order it and massage it any way you wish before you start to print the report.
HTH
Barbara
>Example: User Enter these Fields thru Forms screen
>
>txtShipName - Text box containing the Ship Name
>txtCompleteDate - Text box containing the Complete Date
>cmdRunReport - button will be use to fire the form
>
>Question: What is a fast way of creating cmdRunreport button
>on the form?