Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005

    Unanswered: Using cmd buttons to open sub-forms

    I am working on a database to hold the data regarding our company vehicles. I have a table for the details of the vehicle (i.e Registration, VehicleType, Drivername etc) and a number of tables for different types of equipment (AccessEquipment, LiftingEquipment, StandardEquipment and others).

    I have a form that runs on a query with the criteria to search for the registration number. I have also set up forms to show each type of equipment to use as sub-forms. I would like to have on this main form a number of command buttons that would open the specific sub-form on the main form.

    How can I do this? Any ideas would be greatly appreciated?

  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    Hi Neil

    You would need to create a sub form control. From there it is simple - have each button set the subforms SourceObject property to the name of the form you want to display

    pootle flump
    ur codings are working excelent.

Posting Permissions

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