Access 2003 - report to show filtered records

Oh heck, VBA...

Is that dead simple, or headache inducing for a simpleton like me?

Alternatively, can I link my report into the table, so that when I filter the table, only the filtered records show in the report?
I've been trying all day to go down this route, by setting the controls in the report according to the format
=[Wedding]![Male's Surname]
where Wedding is the name of the table, and Male's Surname is one of its fields.
But when I preview the report I get an 'Enter Parameter Value' dialog box, requesting a value for 'Wedding'.

Any advice?
Thanks

It may be headache inducing, but here's the general theory.  You create a form with comboboxes/textboxes/etc containing the data you want the user to filter by.  Then, when the user generates the report, you display the form and feed the resulting SQL statement to the report.

I think I see where you're going with filtering the table, but I have never tried it that way.  Alternatively, you could alter the WHERE statement of the SQL in your report to be something like so:  "WHERE Wedding.[Male's Surname] = [Enter Male's Surname]"  In this way, when the report is run, it will display a parameter box like you are already getting and will filter on whatever the user types in.  (If they misspell the name though, it will be blank)

Sounds better! In numbered steps, how would I set that up?
Presumably I go to the Report's properties, but which tab etc?
Thanks

Basically you will do the following:
1) Open report in design view
2) Right click on the report and select "Properties"
3) Change the combobox to "Report"
4) Select the "Data" tab
5) Click in the "Record Source..." box and press the "..." button when it appears.
6) Close the table list window and right click on the query that's displayed on design view and choose "SQL View"
7) Locate the "WHERE" clause and add it to the end of the SQL statement
8) Close the report and save

If that doesn't work, copy and paste your SQL statement, and I'll help you add the necessary SQL

This is so kind of you. I really feel we're close now!
It all worked up as far as step 7 - 'Locate the "Where" clause...'

Without the clause the SQL view reads like this:
SELECT Wedding.Date, Wedding.Church, Wedding.Time, Wedding.[Male's Surname], Wedding.[Female's Surname], Wedding.Bells, Wedding.Choir, Wedding.Officiant
FROM Wedding;

If I add your suggestion above it looks like this:
SELECT Wedding.Date, Wedding.Church, Wedding.Time, Wedding.[Male's Surname], Wedding.[Female's Surname], Wedding.Bells, Wedding.Choir, Wedding.Officiant
FROM Wedding;WHERE Wedding.[Male's Surname] = [Enter Male's Surname]

When I try to save the code an error message displays: Characters found after end of SQL statement. So I can't save it.