Create a report from and input form

[Joyfully]

I and a new user of MS Access 2003, and I need help with a report created from a form. I created a form that data is inputed weekly. I created a report to display this data in putting only the last entry from the form in the report by putting Last(field name) in the ControlSource of each field on the report. The report pull the last entry, but it repeats it as many times as I have records in the form. How do I get the report to only show the last entry on the input form once?

[hyperpau]

I suggest that you do not use that form to print your report.
create another form where a user can select the week they want a report for, using a combo box.

This form is unbound and supplies a parameter for a query. the combobox in this form is unbound but has its rowsource from the table where you input your weekly entries. Let's say the primary key of each of your entry is WeekID. Then this combo box lists the WeekIDs that user can select.


create a query for the same table where your input weekly entries.
now, put the parameters in that query looking up the primary key field in your form.
In this example, Week ID.
Then on the WeekID field of your query, put this criteria:
=Forms!YourFormName!WeekID

now that it is set up, bind your report to that query.
program your command button to open the report directly.
therefore, whatever is the entry that is currently in your form, that is the only record the parameter query looks up to. then this query passess that to the report without the user ever knowing it. Then since this query only has one record in it, then your report bound to it would then only have one record.

I and a new user of MS Access 2003, and I need help with a report created from a form. I created a form that data is inputed weekly. I created a report to display this data in putting only the last entry from the form in the report by putting Last(field name) in the ControlSource of each field on the report. The report pull the last entry, but it repeats it as many times as I have records in the form. How do I get the report to only show the last entry on the input form once?