Results 1 to 4 of 4

Thread: Integer syntax

  1. #1
    Join Date
    Jul 2004
    Posts
    64

    Unanswered: Integer syntax

    I have used similar to the following code to filter a linked form and have it update as I move through the records on a main form. The previous (working) one I had was using a text field to link the 2. I am using similar code on a form I have now, only the linking field is an integer. The form opens fine and is filtered, but when I scroll to the next record, the linked form does not update. Any suggestions?

    Code:
    Private Sub FilterPhoneNumEntryForm()
      
      	If Me.NewRecord Then
      		Forms!frmPhoneNumEntry.DataEntry = True
      	Else
      		Forms!frmPhoneNumEntry.Filter = "CustomerIDFK = " & Me![ID]
      		Forms!frmPhoneNumEntry.FilterOn = True
      	End If
      
      End Sub

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    What event are you calling this sub from?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Jul 2004
    Posts
    64
    It is part of an onClick for a toggle button. I can post the entire code if you need it.

  4. #4
    Join Date
    Jul 2004
    Posts
    64
    Actually I got it.. I forgot to filter the child form on my parent form's OnCurrent event. Thanks for trying to help though!

Posting Permissions

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