Hello,I am developing a web application using ASP, ADO, JScript, and MS Access.I am having difficulties with viewing a recently updated record in its 'new' status.I am not certain if the discrepancy lies within my SQL query, or in my coded ASP pages.Specifics: My Transactions Table has 7 fields: TransactionID [autonum], TransactionTypeID [num], UserID [num], JobNo [number], StageDate [date/time], Notes [test], Sequence [number].The purpose of the table is to provide a transaction history for each Job number stored - its current status, date, notes from user, and the sequence number is incremented through a function which lives in an included page.Example of issue: Let's say job number 1100 was in status of 'billing' and now its status has changed to 'closed'. First the sql selects correct record, then a status edit page appears; user forms on the page collect new 'status' information, and is submitted to the editGO page which executes the ADO update command.Checking manually in the AccessDB, I find that the new record was successfully added to the Transactions table.BUTWhen I return to my status info pages, and look for things in the status of 'billing', my recently changed job is still being reported in 'billing' status. When searching for things in the status of 'closed', my job 1100 is listed there as well.If someone may have some input for me? I realize there may be more detailed info needed in order for one of you smart folks to come up with suggestions for me...so i will wait to hear from someone.Many thanks before-hand for your time and assistance!Sincerely,Christina~