Results 1 to 2 of 2
  1. #1
    Xeonni is offline Novice
    Windows 8 Access 2007
    Join Date
    Apr 2017
    Posts
    4

    Novice - need Help with 2007 Preview Report button on Form

    I placed a Preview Report button on my forms and it works sort of ...
    the first time you click it it shows a blank report so i close that report window and click the button on the form again and it will show the record that i wanted then i will close that report page
    then i choose a different number record then click on the preview report button again and it shows the last one i looked at ... so again i close that report ... click the button and it will show the one i want

    don't understand why it is taking two clicks of the button to get the proper report to show up.

    OH FYI i am fairly novice at Access (last time i had a grasp on Access was college in 1997 using Office 95 and never used it since i left college so have forgotten everything and everything has probably changed in those 10 yrs anyways if i did remember lol )

    here are pics of the Form View (combo box for choosing the record number) and the other two pics are what i put in for the the Preview Record button.



    Click image for larger version. 

Name:	Form view.jpg 
Views:	10 
Size:	154.5 KB 
ID:	28258Click image for larger version. 

Name:	button codes.jpg 
Views:	10 
Size:	102.9 KB 
ID:	28259Click image for larger version. 

Name:	button codes2.jpg 
Views:	10 
Size:	86.6 KB 
ID:	28260



    Here are pics of what reports look like on first click and then on second click same record

    Click image for larger version. 

Name:	report on first click.jpg 
Views:	10 
Size:	75.8 KB 
ID:	28262Click image for larger version. 

Name:	Report on second click .jpg 
Views:	10 
Size:	111.5 KB 
ID:	28261

  2. #2
    Xeonni is offline Novice
    Windows 8 Access 2007
    Join Date
    Apr 2017
    Posts
    4
    Oh would like to also add it doesn't just do it on this Form it does it on my SewingPatternFRM form also

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 07-23-2016, 09:08 PM
  2. Replies: 3
    Last Post: 10-20-2014, 03:25 PM
  3. Replies: 5
    Last Post: 04-09-2014, 09:42 AM
  4. Print preview button in form
    By data808 in forum Forms
    Replies: 16
    Last Post: 01-31-2014, 11:41 AM
  5. Report preview from sub form
    By Hillary in forum Forms
    Replies: 2
    Last Post: 01-31-2010, 07:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums