Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2007
    Posts
    81

    Unanswered: Open two Detail sub forms

    Hi Dears

    I have contenue form and 2 detail forms.

    I need to open 2 detail forms. the first form (OrgUpFrm) open by Double click on yellow light color record and second form (FreqlUpFrm) open by Double click on dark yellow color record.

    If you can do by option button or check box or any Idea .

    Open this form as a main form (OrgFreqFrm).

    first Detail form (FreqlUpFrm).
    2nd Detail form (OrgUpFrm).

    thanks
    Attached Files Attached Files

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    You could probably add an option box (unbound) and then when the user clicks on the option box, test to see what background color, if bold, and what foreground color of that text line is to open the other form.
    i.e..
    if me.backcolor = 13303807 then........
    or
    if me.forecolor = 0 then....

    It might work.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Apr 2007
    Posts
    81
    Hi pkstormy

    Can you write more detail please.

    thanks

Posting Permissions

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