acViewPreview Clears Form - Access VBA RRS feed

  • Question

  • Hi, first time poster, so apologies if I have broken any rules etc.

    I have a database I am working on in Access 2010, and I populate a form using VBA and DLookup based on a collection of different tables and user inputs. All this works perfectly, but I want to display the form in print preview mode. I've used the line

    DoCmd.OpenForm "Results", acPreview

    but it clears the data from the form. If I manually change the form to print preview mode however, everything works perfectly.

    Does anyone know why this is? Is there anyway around this?

    Thank you

    Monday, March 31, 2014 10:19 AM

All replies

  • I know it's a long time ago but were you able to find a solution to this?
    Monday, November 25, 2019 11:58 AM