SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot Goldilocks's Avatar
    Join Date
    Apr 2003
    Location
    Three Bear's Cottage
    Posts
    126
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Access form auto refresh problem

    I have a database which is linked to an intranet and users can enter information into it via an html form. This database also has an Access form which is normally in use all day.

    If somebody enters info into the database it won't display in the access form until it is refreshed. So I set up an auto refresh function using a timer.

    The problem is that when it refreshes, it jumps back to the first record in the database which is very annoying if you are in the middle of editing a different record.

    Is there anyway to stop it doing this?

    Thanks in advance.

  2. #2
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The easy answer is to remove your timer.
    If people are entering data all day long, you can put the code to repopulate the data into the after_insert event.

    Also you could confirm that you ar use a dynamic recordset to populate your form, instea of a static or forward only one.

    - Richard

  3. #3
    SitePoint Zealot Goldilocks's Avatar
    Join Date
    Apr 2003
    Location
    Three Bear's Cottage
    Posts
    126
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks, I'll give it a go.


Bookmarks

Posting Permissions

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