Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Display Full Master Record from Datasheet (Access 2000 (9.0.4402) SR-1)

    Display Full Master Record from Datasheet

    Using Access 2000 (9.0.4402) SR-1

    I have a Datasheet that displays Master records from a select qryBPermit based on all fields from tblBPermit

    SrtBPermitNo strOwnerName strLocation lngBPermitID

    When I Double Click on lngBPermit I want to isolate the record the cursor is on and open frm_TOC_BP_ACD to display just that one record.

    Private Sub lngBPermitID_DblClick(Cancel As Integer)

    DoCmd.OpenForm "frm_TOC_BP_ACD", , , "[frm_TOC_BP_ACD]![lngBPermitID] = " & Me![lngBPermitID]

    End Sub

    I

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Display Full Master Record from Datasheet (Access 2000 (9.0.4402) SR-1

    Is you datasheet a view of that form? If so, I'm not surprised if you get an error. If not, you don't need to fully reference the where condition. Try:

    DoCmd.OpenForm "frm_TOC_BP_ACD", , , "[lngBPermitID] = " & Me![lngBPermitID]
    Charlotte

Posting Permissions

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