Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2005

    Wink Unanswered: Search all records in subform.

    I have a main form and a subform. I have a find button on the subform that will only search subform records that go with the main form record (one-to-many relationship), how can I get it to search all the records in the subform?

    When I want to search for something in the main form, there is no problem. It works fine when I have just the subform open but does not work when the subform is open inside the main form

    On Error GoTo Err_find_records_Click

    DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

    Exit Sub

    MsgBox Err.Description
    Resume Exit_find_records_Click

    I'm not sure how to code it to get it to search all subform records no matter what record in the main form is open.

    Any help is greatly appreciated!
    Last edited by Zenaida; 01-11-06 at 21:59. Reason: Make my question more clear.

Posting Permissions

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