live query

  • Thread starter Thread starter inungh
  • Start date Start date
I

inungh

I just wonder are there any way to create live query.

For example, I run a query to get my result and at same a user enters
a record which matches my query criteria.

I have to run query again to see the record in the result set.


Are there any way that I do not need re run it to get the data user
just entered?


Your information is great apprecaited,
 
No, a select query is going to return the records that meet the criteria at
the time the query executes. If you want to see new records, the query must be
executed again.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
No, a select query is going to return the records that meet the criteria at
the time the query executes. If you want to see new records, the query must be
executed again.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County








- Show quoted text -
Click to expand...

Thanks millions for helping,
 
i think he means a trigger john and again no access dosnt support
triggers

sorry

Regards
Kelvan
 
A trigger would modify data in the database, but won't refresh a recordset
which is in large part an object in the local computer memory, memory not
even accessible by any database trigger.


Vanderghast, Access MVP
 
Back
Top