Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    33

    Unanswered: how to create a simple form by using two tables

    i know this is a silly question but i am stuck. can anybody tell me how can i create a simple form by using fields from two tables.

    thanks

    Anwar

  2. #2
    Join Date
    Oct 2002
    Posts
    33
    never mind! i got it. i used relationship.

    but now i got new problem that is i have one form using two tables. i need calculation from two fields of two tables. PAID field in PAYMENTS table and DUE field in ASP table. i want when data entered in PAID field it will subtract from DUE field and show the subtracted result DUE field and ASP table will be updated.

    any help will be appreciated.

    thanks

    Anwar

  3. #3
    Join Date
    Oct 2002
    Posts
    33
    i used this code :

    private sub PAID_AfterUpdate
    asp.due=asp.due-payment.paid
    end sub

    is there any wrong code here?

    Regards.

    Anwar

Posting Permissions

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