Auto update form

[Ian Pendlebury]

Access2000 -> SQLServer

I want my Users to be able to display a Form with a
recordset obtained from the SQL Server.

Is there a built in way of making the displayed recordset
reflect changes in the underlying table?.

I know that I code use the Form Timer event to requery the
server at regular intervals. But it would be nice if it
would do it by itself like MS Outlook does.

 

[Arvin Meyer]

Access2000 -> SQLServer

I want my Users to be able to display a Form with a
recordset obtained from the SQL Server.

Is there a built in way of making the displayed recordset
reflect changes in the underlying table?.

I know that I code use the Form Timer event to requery the
server at regular intervals. But it would be nice if it
would do it by itself like MS Outlook does.

Sure, from the menu, choose:

Tools ... Options ... Advanced tab

Change the refresh interval.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access