Hi All,

I have a continuous form with a selection of unbound combo boxes which when selected alter the on screen results accordingly!
These combo boxes filter each result by category or name or type etc. so once the relevant options are selected the continuous form results are displayed!

The problem i have is that i can not print the on screen results! Everytime i do a Preview (using the AcViewpreview command) i only get the whole list of results not what i see on the form!

I have tried applying the filter after the preview command e.g. DoCmd.OpenReport "List Report", acViewPreview, DoFilter (DoFilter being the filter string that filters the combo boxes) but this doesnt work!

I can not add Where conditions as this report will be different every time that the user prints it depending on the options that they select!

Can anyone help please?