Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Location
    New Kensington, PA
    Posts
    17

    Unanswered: Navigation problem in a subform.

    Access Version 2003.

    I have created a purchase order (PO) form with a subform that will collect and calculate a cost savings between the "Original Price" and a "Negotiated Price" for the items on the PO. The last input is the negotiated price, which triggers an "On Exit" event, where VB code correctly calculates the extended price (to an unbound control) and the column totals and cost savings to other unbound contols on the subform's footer.

    Private Sub numPrice_Neg_Exit(Cancel As Integer)
    numPrice_NegExtend = numPrice_Neg * numQuantityDT
    numPriceNegTotal = numPriceNegTotal + numPrice_NegExtend
    End Sub

    Then the program cannot goto or add the next record on the subform. My settings on the Mainform is set at Single Record with the Subform set at Continuous Records. The tables: Main Table to Sub-table are set at One to Many relationship. The tables are linked tables. Any suggestions?

  2. #2
    Join Date
    Oct 2006
    Location
    New Kensington, PA
    Posts
    17

    Talking Problem Resolved

    By changing the "On Exit" to "On Lost Focus" seems to resolve my problem!

Posting Permissions

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