subforms

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • luvfreckles
    New Member
    • Aug 2008
    • 1
    #1

    subforms

    how do i make this formula work in a subform where [XXXXX ID] is in a subform and [temp XXXX ID] is not!!:

    ' Find the record that matches the control.
    Me.RecordsetClo ne.FindFirst "[XXXXX ID] = " & Me![temp XXXX id]
    Me.Bookmark = Me.RecordsetClo ne.Bookmark
    Tags: None
    • hjozinovic
      New Member
      • Oct 2007
      • 167
      #2
      Originally posted by luvfreckles
      how do i make this formula work in a subform where [XXXXX ID] is in a subform and [temp XXXX ID] is not!!:

      ' Find the record that matches the control.
      Me.RecordsetClo ne.FindFirst "[XXXXX ID] = " & Me![temp XXXX id]
      Me.Bookmark = Me.RecordsetClo ne.Bookmark
      Try swaping the two fields:
      Code:
      Me.RecordsetClone.FindFirst "[temp XXXX ID] = " & Me![XXXXX ID]
      Syntax Me![Field] reffers to the field on the form!!!!

        Comment

        Previous template Next
        Working...