Access form auto refresh problem

[Goldilocks]

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.

[asterix]

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

[Goldilocks]

Thanks, I'll give it a go.