HI,
My problem is simple to explain but the solution seems to be eluding me. I have tried both ways VBA and macro to give myself options when printing a report from a form via using a button. The best I can do is give myself the printer screen to come up which lets me select the printer, with properties and about 99% of the options I need. However, the one option I need is the Select Record(s) option (which is greyed out), in the bottom left hand corner of the screen snip I attached. The only work around I have is to input pages from 1 to 1, but I am trying to avoid having users do that. One of the users I have will mess that up and end up printing over 400 pages of reports, so I really need to try and avoid this. Does anyone know how to open this option up for use?