Page 2 of 2 FirstFirst 12
Results 16 to 21 of 21
  1. #16
    accesstos's Avatar
    accesstos is offline Expert
    Windows XP Access 2007
    Join Date
    Dec 2018
    Location
    Greece
    Posts
    551
    OK, I see!



    The "Organization_Verification_P2" is the name of a page (you call it tab). A Page of a Tab Control doesn't provide a member called "Value".

    The code needs the name of Tab Control, not the name of the page.
    Code:
    Me.The_Name_Of_Tab_Control.Value
    When the Value of the Tab Control = 0 you are in Page 1.
    To step to the next Page, you have to add 1 to the Value of the Tab Control.

    To see the name of the Tab Control, click on the blank space right of the last page to select it first.

    Good luck!
    John

  2. #17
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,803
    I guess I should have made it more clear in post 12 that I was referring to a tab control, but I guess I thought the name after Me was self explanatory. I guessed wrong.

  3. #18
    LoriH is offline Novice
    Windows 10 Access 2007
    Join Date
    Apr 2020
    Posts
    17
    Hi John. Okay, thank you! I changed the code to put in the name of the Tab Control (thanks for explaining that). I feel like I'm so close now! But, another error...
    Click image for larger version. 

Name:	VB Code.JPG 
Views:	9 
Size:	25.8 KB 
ID:	41692Click image for larger version. 

Name:	vb error.JPG 
Views:	9 
Size:	38.8 KB 
ID:	41693

  4. #19
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,803
    If your IF statement runs over more than one line you need an End If.
    Google would tell you as much!
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #20
    LoriH is offline Novice
    Windows 10 Access 2007
    Join Date
    Apr 2020
    Posts
    17
    That did it! It works! Thank you all so much! I know its been painful for you... me too! But it works now!

  6. #21
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,803
    Great! Now research Option Explicit because I see that you are not using it.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 08-29-2019, 01:04 AM
  2. Replies: 4
    Last Post: 08-07-2018, 05:38 AM
  3. Replies: 6
    Last Post: 01-01-2018, 10:41 AM
  4. Replies: 3
    Last Post: 03-17-2017, 08:00 AM
  5. Create an RDP link button on my form
    By BDP in forum Access
    Replies: 1
    Last Post: 09-14-2010, 02:49 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
  •  
Other Forums: Microsoft Office Forums