Report re-print

[gchichester]

I have a db that I use for tracking information, It has just few forms and 1
report.
After a recorded is entered and saved, I open a report of just that record
and email it,
which works fine. When I try to reprint a existing record/report using this
simple query

SELECT [Booking Notice].*, [Booking Notice].[Booking no]
FROM [Booking Notice]
WHERE ((([Booking Notice].[Booking no])=[Enter Booking Number]));

it runs and then displaying print preview of the report,
the first report is the one queried, but it also displays a report for every
record
in the db.
Any ideas what I'm doing wrong.

Thanks for any and all comments

Gilc

 

[gchichester]

Never Mind - I got it working with a filter!