Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    44

    Unanswered: Refreshing records in a query

    I created an order entry/inventory tracking program. The main user form will select an item from a combo box , enter a
    qty and that number will be deducted from the Qty in Stock.

    In addition to that, the user can push a command button to
    view that item's details, which is on another form called Item Description.

    What I want to achieve is for the user to see all past transactions involving that ItemID. I have it working, but it won't show the current record. After I exit the program and come back, the records are refreshed. The subform that the transactions are based on is based on a query.

  2. #2
    Join Date
    Nov 2003
    Location
    Europe
    Posts
    369

    Re: Refreshing records in a query

    Are you sure that the actual record is saved before the user pushes the command button?

    You could put a record save command in the control's AfterUpdate event, perhaps. Also, are you sure that the form that the command button is not already open? If so, try putting

    Me.requery

    in that form's OnCurrent event.

    D.

  3. #3
    Join Date
    Mar 2004
    Posts
    44
    I knew it had to requery somehow, I just didn't know where to add the code. Thanks!

Posting Permissions

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