Åben forespørgsel med kriterie fra checkbox på listbox

Lars why do you want to open a query? Could you not open another form which is based on the query and then ise the same method as in the example to open the form instead of the query with a criteria.

and Lars, you still have a couple of open questions you could maybe look at, for example http://www.eksperten.dk/spm/701951.

Jeg skal åbne en opdateringsforespørgsel, som opdaterer nogle priser. Men kun på de varer, som brugeren vælger i træet. Jeg skal nok kigge på de spørgsmål

Hi Lars

I'm at work at the moment so I dont have the example dB here. But if I remember correctly the code in the example builds the criteria to the report. The report is based on a table.

You should be able to replace the criteria with the FULL update SQL including the criteria abnd then make query out of it.

I'll get back a bit later and make an example for you.

Tak skal du have :-D

In the example I have added a new field to the Bog table with the name NewField, just so you can see what is happening.

Now in the code I have changed comment out the last line which currently opens the report and I have also added a new line.



        'DoCmd.OpenReport "Bøger", acViewPreview, , SQLStr
 
        DoCmd.RunSQL "UPDATE BOG SET BOG.NewField = 'This is a test' WHERE " & SQLStr



Now when you choose records you will get a warning that you arr updating them and also you can see in the table the changed records.

Mange tak for hjælpen. Det virker jo super fint. Hermed points til dig

Thanks :o)