Post reply

Find Records Sub Form

  • March 26, 2004 at 6:28 am

    #65546

    I have created a DB that tracks purchase orders.

    I have a "PurchMain" form that has PO no; Vender;PO date ; Shipping info etc and a "PurchMain_Sub " form that has the detail items for each PO. ie PO # 1001 has items A,B ,C... .

    I need to be able to search the DB and return the PO info. If I do a Filter by Form on my Main form it doesn't return info from my sub-form. Filter by form on the sub-form doesn;t work either.

    This basically makes this DB worthless as the user is unable to search for records. (eg PO from this vendor ; PO between these dates; PO for these items no. )

    The 10 year old POS Lotus approach  DB that I am trying to replace does  this with no effort.

    Thanks

  • March 29, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • March 29, 2004 at 8:35 am

    #500890

    I don't know if this is what you are looking for, but you can use this code behind a list box or a combo box that lists all of the POs.  It moves the current record to the selected PO.

    Dim rs As Object

        Set rs = Me.Recordset.Clone

        rs.FindFirst "[PO] = '" & Me![List0] & "'"

        If Not rs.EOF Then Me.Bookmark = rs.Bookmark

    Access also does this with a wizard on the list box and combo box.

    Richard

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply