Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    The Netherlands
    Posts
    98

    Unanswered: Multiple queries in one form

    Hi,

    I have a table with 7 fields. I have made several queries based on this table alone. The queries have the following fields:

    1. Autonumber
    2. Subject (text)
    3. Description (memo)
    4. Domain 1 (Look up field)
    5. Domain 2 (Look up field)

    In the query I state that I want only domains with a 1 (or a 2 or a 3). In the form I wish to have tabs in which each one shows a different query (eiter domain 1, or domain 2, etc.)

    The thing is I just can't get my head around how to do this. PLEASE help me move in the right direction (or any direction for that matter!)

    Thanks,
    Charlotte

  2. #2
    Join Date
    Jan 2004
    Location
    Jersey, UK
    Posts
    108
    If you're using the tab control, you could in fact create a form for each query type you've mentioned and then include those forms as sub-forms in each of the tabs. No programming or fancy work required.

    Hope this moves you in the right direction.


    Regards - Andy

  3. #3
    Join Date
    Dec 2003
    Location
    The Netherlands
    Posts
    98
    I tried this, but seeing as the lookupfields I described have a number that links them to the table, I see the number on the form. I just can;t think how to change this so all you see is the name of the field and not the number.

    Any ideas on this one?
    Last edited by charlottevk; 03-31-04 at 07:22.

Posting Permissions

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