Results 1 to 2 of 2

Thread: Pop Up Subform

  1. #1
    Join Date
    Aug 2002
    Posts
    78

    Unanswered: Pop Up Subform

    I am using Windows XP and Office 2000. I have a db using structure as follows.

    Tab Control Tab one Contact Information (tblContacts)

    tblContacts
    ContactID PK
    Fname
    MI
    Lname
    Address
    City
    State
    Zip
    Etc. . .

    tblApplications
    ApplicationID PK
    ApplicationDate
    MaritalStatus
    NumberInHome

    Etc


    tblIncome
    ApplicationID
    IncomeID PK
    Employed
    Employer
    Income
    Source

    Currently there is only on application to Contact. One to One relationship. Applications to Income however is one to many relationship.

    I am using Tab control Contact information on first tab, Application information on second tab. I would like frmIncome to open on a button. Keeping the relationship to the application however I can only get a viewable version. Entering information give me error about having application ID.

    How can I invoke the income subform to the Application form on the second control tab please?

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    after update of IncomeID PK, check if the isnull(ApplicationID) =-1 then
    ApplicationID = forms!TabbedFormName!...

Posting Permissions

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