Udvælgelse af rapport

what you could do is set a filter on the report so that you only make a report for the required data.

how do i do that and can it be done with a macro?

I NEVER use macro\'s, but in code it looks like this.

DoCmd.OpenReport \"YourReport\", acPreview, , \"User ID = 1\"

how can i define the page to be shown from a search on eg. a company name?

And what does \"User ID = 1\" mean?

The \"User ID = 1\" is the same as the WHERE clause in an SQL Query. You can build this in code.
In this example I have a combo where I choose a user and use this in the filter. I could also have other paramaters and use the AND.

Where .... AND .... etc.

MyWhere = \"UserID = \" & Me.cboUserID

DoCmd.OpenReport \"YourReport\", acPreview, , myWhere

You have a form where you can have a field for each paramaters which you can use for the filter.
Then you can test each field (or combo) to see if something is entered, if so then append this to your where (myWhere).



The userID was just an example, I dont have your database, so have no idea what fields you have....

when i do this i get a message like this: \"The table \"Virksomhedsdata\" can\'t be locked as it is used by another process\"

What\'s wrong - and how can i help it?

This should give any problems, opening a report with a filter is a normal thing.

You could send your database to me and I will take a look for you.

If you also tell me what you want to filter on then I will see what I can do!

dkTeBrSa@Europe.LEGO.com

should= should NOT

Do you still need help on this question?