Any suggestions

[ian_ok]

I have a report that shows all the properties I have registered, what I want to do is have this report just to show the ONE I pick from maybe a combo box list?

From this 1 report I will Publish it in MS word, so I can email this as an attachment to anyone I wish too.

1. How do you do the first bit?

2. Is it possible to have the combo box to run the whole command, ie when you click on the persons surname, it publishes it in word for you saving over the previous one.

3. Any other suggestions will be accepted.

Thank Ian


[This message has been edited by ian_ok (edited 07-10-2001).]

 

[ian_ok]

Ok, so no responce...........SO...........


...How can I just display one landlord's report from a combo box I put in a form I design...In other words I think I need a filter....I've not worked with these...Help

Ian

 

[Fornatian]

1.Build a query with all the fields for the report.
2.Add a combo box to a form and set it's recordsource to whatever table you want to reference. Include the primary key as the first field. Set it's name to cboCriteria
3.Usually if the primary key is an autonumber you won't want it displayed so set the width of the first column to 0 in the controls properties.
4. In the query reference the control:
Forms!MyForm!cboCriteria
(hint: this is easier to do if you leave the form open and use the expression builder because you'll get an option under the forms branch for 'loaded forms'. Right click in the criteria row for the build option that initialises the expression builder.

Ian