Access Updating and Retrieve

Results 1 to 3 of 3

Thread: Access Updating and Retrieve

  1. #1
    David Willems Guest

    Default Access Updating and Retrieve

    Heres my problem....<BR><BR>I am updating an Access table no Problem. However, I want to then grab that new record that I added to display on the same page i insert the data with or the page after it.<BR><BR>THe table has a Autonumber so I do nothing with that field unless I use it to pull the information.<BR><BR>How do I grab that newly input record using the Autonumber field?<BR><BR>Can I at all?<BR><BR>Thanks for any help.

  2. #2
    Join Date
    Dec 1969

    Default RE: Access Updating and Retrieve

    You can set up a query that retrieves all the records in desc order by autonumber. Then you can just use the first record it finds.

  3. #3
    Jing Guest

    Default RE: Access Updating and Retrieve

    Read one of the article in the Commonly asked Messageboard Questions, it does have solution in there helped me out for the same Qz.. :)..4 Access Users..

Posting Permissions

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