Auto update form

  • Thread starter Thread starter Ian Pendlebury
  • Start date Start date
I

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.
 
Ian Pendlebury said:
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.
Click to expand...

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
 
Back
Top