Results 1 to 7 of 7

Navigating Around Forms

Threaded View

  1. #1
    Registered User
    Join Date
    02-14-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    7

    Navigating Around Forms

    Hi Guys,

    This is probably going to be a stupid thread but it's driving me insane now.

    I have 5 forms in my application and I'm just trying to navigate around them using buttons to go from Main Menu to the next form etc.

    My first move is when the Button "cmdreports" is clicked on the frmMain form it opens frmReports.

    In VBA on the Form frmMain I've inserted:

    Private Sub cmdreports_Click()
    frmReports.Show
    End Sub
    However when I run this I get the "Run Time Error 424: Object Required".

    I don't need to declare all my Userforms do I? I was under the impression I didn't as there objects within Access anyway.

    Any help would be greatly appreciated.
    Last edited by BayEnder111; 10-26-2014 at 03:19 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Not inserting cell references when navigating forms.
    By AnotherDaveC in forum Excel General
    Replies: 2
    Last Post: 04-11-2013, 10:32 AM
  2. Excel 2007 : Navigating Worksheets
    By whitepaw in forum Excel General
    Replies: 2
    Last Post: 05-12-2011, 06:55 AM
  3. Print on ready blank forms (document forms)
    By gandrinno in forum Excel General
    Replies: 1
    Last Post: 02-16-2009, 06:12 PM
  4. Excel forms - authorise / deny forms
    By Ian Manning in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2006, 12:10 PM
  5. Navigating
    By Gibbie in forum Excel General
    Replies: 9
    Last Post: 01-31-2005, 07:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1