Ccombo box selection in report

[TwoDodges]

I have a report that shows member contact information and lists certain details for each member in main body.
At the moment the report defaults to print preview and has record selectors a bottom.



Can I put a combo box for record selection overlaying the report to enable select record to print ( select by surname / memb ID ) ..???
... all attempts to do so / find out -- no avail

[Minty]

Reports aren't really the place for this, I would do it in a form that then opened a restricted record source for the report.

Report data is effectively static, ready to print. Changing it dynamically, whilst possible, means re-rendering the entire report, which could be quite slow.

[TwoDodges]

OK ... I have placed a button on my form to open the reportand have created query that displays data for report, but I can not get the button to pass the required field data [ Members_MembID ]to the query.
It brings up a window asking me to input value into that field.
If I do it then gives me the report... I assume I have got the incorrect syntax for the query ... = form name/field name ( [Form]![Members_Vehicles]![Members_MemID] )
Help GREATLY appreciated ..!!

[Welshgasman]

Show the query sql

[TwoDodges]

I have removed some of the fields to abreviate ..
This is from the query that runs the report .....
the form the ID number that is passed to the query is 'Members_Vehicles' and field is 'Members_MembID'

SELECT Members.MemberID, Members.Surname, Members.Firstname,
….. + other fields
FROM Members RIGHT JOIN autolist ON Members.MemberID = autolist.MemberID
WHERE (((Members.MemberID)=[Form]![Members_Vehicles]![Members_MemID]))
ORDER BY Members.Surname;

[Welshgasman]

I cannot see anything wrong with that, BUT if access is asking for a value, it cannot find it?
Check your names.

In fact, if I use the builder for the sql, it is [Forms]![Members_Vehicles]![Members_MemID]
So when it doubt, use the Builder to get the correct syntax.

I rarely tied queries to form controls, so not familiar with the syntax, but then, I'd google for it, to make sure

[TwoDodges]

O for the sake of an "S" ...
added the 's' to the 'form' and miracles happen !!!
will have to watch that for future reference ...

MANY Thanks