Get value from another table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have 2 database tbl_inv and tbl_coursePayment

The form Course payment use tbl_coursePayment. The form has a field named
Invoice No which obtain the value from tbl_inv.no + 1 as a New Course Payment
Invoice no.

The process is
1. get invoice no from tbl_inv.no
2. put the tbl_inv.no + 1 as new coursePayment invoice no
3. write back the new invoice no to tbl_inv.no when the form save

I m newbie in VBA, would somebody give me some example code for my reference.

Thank you.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200802/1

.

Relevant Pages

  • Re: Macro
    ... What database are you used to? ... to have a frame of reference, ... Sounds like you want a main form (Invoice) with a subform ...
    (comp.databases.ms-access)
  • Re: Get value from another table
    ... in the Event tab click the ... ... Before Update and choose code builder. ... Invoice No which obtain the value from tbl_inv.no + 1 as a New Course Payment ...
    (microsoft.public.access.formscoding)
  • Re: Using two columns as a primary key
    ... I have a database of my own records which are invoices I work on. ... These invoices are from four companies with their own invoice ... reference each record. ... include the company code as part of the number (either as text or as ...
    (comp.databases.ms-access)
  • Re: Using two columns as a primary key
    ... I have a database of my own records which are invoices I work ... I cannot key by invoice number because ... using a created index to reference each record. ... number and include the company code as part of the number ...
    (comp.databases.ms-access)
  • Re: Date / Autonumber anomaly
    ... start a brand new database beginning with new invoice/record numbers. ... think the corruption may be due to the age and size of the database. ... corruption doesn't get carried forward because it exists in your invoice ... but the intent of Autonumber is to ...
    (comp.databases.ms-access)