Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2007
    Posts
    148

    Unanswered: report from a from with unbound text value.

    Here is my problem, hope someone can give me some direction

    1) I want to print a contract.
    2) The ContractForm update the value to the tblContract table
    3) the tblContract table only store needed information, NOT all information from the ContractForm
    4) Well, in the ContractForm, user will be presented 2 names to choose from for the contact person for the contract ( try to say that 10 times fast :-)).

    5) When user pick the contact person he likes (a check box will be checked for that choosen contact person), the form will automatic populated the rest of the information of the choosen contact person: e.g. email, phone, address and etc.

    6) the control box holds these email, phone, address and etc are unbound box.

    7) My form always present the correct contact person for each contract base on the check box field of each contact person from the tblClient.

    8) Now, my problem is when I try to print that contract. My report will query the tblcontract which does not have all the contact person information: address, phone and etc.

    Now, I am thinking if I can somehow just before I click my print button on the ContractForm, I can run a query to upload the current form value (all the bounded controls and unbounded controls) to a temparory table. THEN, I can run my report against that temparory table. However, I don't know how to upload all the control value in a form to a temporary table.
    Last edited by sweetmail; 09-24-09 at 18:10.

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Look at "DemoRptUnbA2000.mdb" (attachment, zip).
    Open Form1 and try.
    I think it is what you need.
    Attached Files Attached Files

  3. #3
    Join Date
    Sep 2007
    Posts
    148
    It is. THANK YOU SO MUCH!!!!

Posting Permissions

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