Results 1 to 4 of 4
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Subform Navigation (Access 2003/SP3)

    I have an order form that I've diagrammed below.
    What I would like to have happen is that as the user indicates the number on order and/or the number received in the subform, that the fields in the main form (Remaining items to order, Items on Order, Total Received ) are updated.
    Unfortunately what happens is that as those numbers are updated it flips the subform back to the first record.

    Any suggestions...
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Subform Navigation (Access 2003/SP3)

    You haven't told us what method you use, but from your description I would guess it involves Requery. Try Recalc instead.
    If that doesn't work, please provide some details.

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Subform Navigation (Access 2003/SP3)

    I've tested Recalc and Requery.

    These fields are all unbound - using queries to acquire the total values.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Subform Navigation (Access 2003/SP3)

    I'm afraid we'll have to know much more to be able to help you. It would be easiest if you could post a stripped down copy of your database. See <post#=401925>post 401925</post#> for instructions.

Posting Permissions

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