Results 1 to 2 of 2
  1. #1
    trevor40's Avatar
    trevor40 is offline Advanced db Manager
    Windows XP Access 2003
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    402

    Pause code until return from call command

    I have a command button to proccess required actions - check entries, set mail list, create mail...
    I would like to add an option to pause this code if the user wants to print labels for the current record, and then procede with the rest of the code...

    Select Case MsgBox("Would you like to print box address labels now ?", vbYesNoCancel, "print box labels")


    Case vbYes
    DoCmd.OpenForm "print box labels", acNormal, , , , acDialog
    Case vbNo
    'continue with proccessing
    Case vbCancel
    Exit Sub
    End Select

    This works but when I then when I preview the report it is under the print box labels form?

  2. #2
    trevor40's Avatar
    trevor40 is offline Advanced db Manager
    Windows XP Access 2003
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    402
    Fixed it, open the report as acDialog as well !!!!!!!!!!

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

Similar Threads

  1. Report Code is not allowing return to main code
    By rcwiley in forum Programming
    Replies: 2
    Last Post: 06-16-2013, 10:31 AM
  2. Code to call Split Form View Datasheet
    By ahightower in forum Programming
    Replies: 1
    Last Post: 07-28-2011, 04:57 PM
  3. Form command button to do something/call function
    By shubhamgandhi in forum Programming
    Replies: 2
    Last Post: 07-27-2011, 04:45 PM
  4. Call .dll Code On BeforeUpdate?
    By phi11yguy19 in forum Programming
    Replies: 0
    Last Post: 07-02-2011, 10:20 PM
  5. Pause state?
    By Zermoth in forum Programming
    Replies: 1
    Last Post: 12-15-2008, 05:05 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