Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Help with this Form? Please!

Discussion in 'Information Technology' started by Keensie, Jul 28, 2006.

Tags:
  1. Keensie

    Keensie
    Expand Collapse
    Guest

    I have a form which shows records in datasheet view, when I select any record
    by double clicking on it I have another form opening showing only the record
    I selected. I did this by creating a query for my second form with a pointer
    (in the criteria) to the field in the main form which matches with one of the
    fields in my second form. This works fine whenever I am in the main form but
    I have embedded the main form and now when I double click on a recorded I get
    the following prompt: Enter Parameter value… Could someone kindly advise me
    as to how to get rid of this prompt?
     
  2. Loading...


  3. SusanV

    SusanV
    Expand Collapse
    Guest

    Since it is now a subform, you must reference the parent, then the subform,
    then the control:

    Forms!Parentform.SubformName.Form!ControlName
    --
    hth,
    SusanV


    "Keensie" <keensie06@hotmail.com> wrote in message
    news:EB63E2AF-54BB-43FB-87BA-CC4809D4634A@microsoft.com...
    >I have a form which shows records in datasheet view, when I select any
    >record
    > by double clicking on it I have another form opening showing only the
    > record
    > I selected. I did this by creating a query for my second form with a
    > pointer
    > (in the criteria) to the field in the main form which matches with one of
    > the
    > fields in my second form. This works fine whenever I am in the main form
    > but
    > I have embedded the main form and now when I double click on a recorded I
    > get
    > the following prompt: Enter Parameter value. Could someone kindly advise
    > me
    > as to how to get rid of this prompt?
     

Share This Page