Results 1 to 3 of 3
  1. #1
    Gavroche is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    7

    Form Code issue

    Good afternoon all,



    I haven't programmed in 7 years. Totally forgot but decided to help my temple, so I set up a menu. Here is the code problem I have:


    Private Sub EntreeID_LostFocus()
    If Me.EntreeID.Value = 10 Then
    Me.DressingID.Visible = True
    Me.BreadID.Visible = False
    Else
    If Me.EntreeID.Value > 16 Then
    Me.DressingID.Visible = False
    Me.BreadID.Visible = True
    Else
    Me.DressingID.Visible = False
    Me.BreadID.Visible = False


    I need to finish this lost focus object by telling it to go to the next record and I completely forgot how to. I thought me.goto.nextrecord but that really doesn't work. Thanks

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    Hi
    I think that this is what you need
    Code:
    DoCmd.GoToRecord , , acNext
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    Gavroche is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    7
    Bob,

    Thanks, that did it. The rust is slowly going away.

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

Similar Threads

  1. Form (switchboard) issue
    By kwoods in forum Forms
    Replies: 8
    Last Post: 06-10-2011, 06:56 AM
  2. Blank Form Issue
    By Gray in forum Forms
    Replies: 3
    Last Post: 05-23-2011, 12:11 PM
  3. Form Minimize Issue
    By Tomfernandez1 in forum Forms
    Replies: 8
    Last Post: 05-18-2011, 05:32 PM
  4. Replies: 1
    Last Post: 03-18-2011, 03:22 PM
  5. Table/Form Issue
    By ginap in forum Access
    Replies: 3
    Last Post: 06-17-2009, 01:12 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