Post reply

ADP

  • July 10, 2003 at 5:57 pm

    #83796

    Hello there

    Just wondering if anyone knows how to code into an access adp form, the ability to open another form and display a record filtered by the primary key of the table behind this new form, this is triggered by double clicking on a record in a list box on the original form ??

    Regards

    J

  • July 14, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • July 14, 2003 at 8:44 am

    #465349

    Hi J,

    quote:

    Just wondering if anyone knows how to code into an access adp form, the ability to open another form and display a record filtered by the primary key of the table behind this new form, this is triggered by double clicking on a record in a list box on the original form ??

    I'm not sure if I understand you, but you can create and Access event firing on double click on listbox. You then can open a form by something like

    DoCmd.Openform,,,,

    One of the parameters allows you to specify a filtercondition for the new form.

    Is this what you are looking for?

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • July 14, 2003 at 6:37 pm

    #465473

    Yes thats it, thanks Frank

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

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