Results 1 to 2 of 2
  1. 01-21-2012, 05:03 PM #1
    qbc
    qbc is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Aug 2009
    Posts
    30

    Main Form If Statement

    Hi,


    I have a main form with buttons on it. When clicking one of the buttons, I have set it to run a query and prompt for the parameter. If the parameter is entered correctly, then everything is fine.

    If no results are found, I'd like the form to return a message like "nothing was found" AND return to the main menu.

    Is there any way to accomplish this?

    Thanks
    Reply With Quote Reply With Quote
  2. 01-21-2012, 05:27 PM #2
    qbc
    qbc is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Aug 2009
    Posts
    30
    solved. thanks.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Subform opens new form that gets its info from the main form. *yuck!*
    By danbo in forum Access
    Replies: 35
    Last Post: 12-21-2011, 02:16 PM
  2. Use 2 listboxes to select field from main form and subform to open form in edit mode
    By xwnoob in forum Forms
    Replies: 1
    Last Post: 12-04-2011, 09:11 PM
  3. How do i prevent sub-form add record button from enabling unless main form is dirtied
    By xwnoob in forum Forms
    Replies: 1
    Last Post: 11-21-2011, 07:58 AM
  4. Open a Form by clicking a record in a Subform in a Main Form
    By dinoliciouz in forum Forms
    Replies: 5
    Last Post: 11-11-2011, 11:06 AM
  5. passing variable from modal form to main form
    By crowegreg in forum Forms
    Replies: 2
    Last Post: 06-03-2011, 05:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums