live query

[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,

 

[John Spencer]

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

 

[inungh]

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 -

Thanks millions for helping,

 

[Lord Kelvan]

i think he means a trigger john and again no access dosnt support
triggers

sorry

Regards
Kelvan

 

[Michel Walsh]

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