Results 1 to 2 of 2
  1. #1
    Join Date
    May 2011
    Posts
    6

    Unanswered: run into records in a form (related with another form)

    Hello!

    I have a (big) problem. I want to open a form which will show some resultds acording with another form. For example I have a list of clients that is related with a one to many relationship with a list of contracts and I want to select one client in one form and show the contrats in the other form.

    My problem is, how can I make the command buttons work and run into records?

    PS: I want this in vba and I don't want to use subforms.

    Regards

  2. #2
    Join Date
    May 2010
    Posts
    601
    If you wan to use a pop-up form then you wil need to figure out how to pass the clients primary key.

    A simple way is to use the DomcdOpen form and use the Where Parameter to filter the data. The command button wizard will create the VBA code for you.
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

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