Results 1 to 4 of 4
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Tab Control & subform (A2K)

    I can't explain why you can't go to another tab page, but I don't understand why the record source of the main form includes tblSub. I'd think the main form should be based on tblMain only and the subform on tblSub.

    If you wish, you can post a stripped down copy of your database. That will enable Loungers to investigate the problem directly. See <post#=401925>post 401925</post#> for instructions.

  2. #2
    2 Star Lounger
    Join Date
    Feb 2002
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Tab Control & subform (A2K)

    My form has a Tab control with 5 pages. The Tab control is populated with SQL "Select * from tblMain Inner Join tblSub on [tblMain].[ID] =[tblSub].[ID]". On the last page is a subform with the Link child filed ID and Link master field tblMain.ID. The record source for the subform is "Select * from tblSub"

    I can navigate to all the pages with data from tblMain. However when I activated the tab page with the embedded subform and tried to enter some data, I could not go to another tab page and was stuck at the tab page with the subform until I exit the program.

    With this sketchy description, can anyone tell me what is (are) the possible reasons?

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tab Control & subform (A2K)

    tblMain and tblSub are two tables related by ID (one-to-many relationship). The tab control essentially displays data from tblMain but with the last page displays data, if any, from tblSub. The tblMain is actually the student info and tblSub indiscipline records, one indiscipline kes one record. I want to add records of indiscipline of a particular students if there is one. Am I not using the query correctly?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Tab Control & subform (A2K)

    Since the last tab page has a subform based on tblSub, you don't need tblSub in the control source of the main form - the main form should be based on tblMain only.

Posting Permissions

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