A form which automatically updates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
i have a database system where i need a front screen which could be on a
switchboard/form, it needs to automatically display orders that come in that
do not have a status, i can make a query to show which records do not have a
status, but how do i get the form to automatically display any records, and
once there are no records i need a message to be displayed or it could remain
blank, but the main feature is the automatic updating of the screen when a
new order is entered into the database.

thanks
 
Base the form on the query instead of a table. The query should be
updateable, but that should be easily accomplished by adding a Where clause
in the query in the status column: Is Null
 
Hi,
thanks i shall base the form on the query but i am afraid i do not get the
ending of your suggestion, i am a rookie at access so if i could ask you to
please explain the last bit about the clause, i dont understand it?

thanks
 
In the query grid, there is a Criteria box. Actually all the boxes below the
"Show" box are criteria boxes. If you type an expression like:

Is Null

in the Status column, you should be able to see only the records which do
not have anything in the Status column. If you change to the SQL view,
you'll see that the query reads something like:

SELECT tblName.*
FROM tblName
WHERE tblName.Status Is Null;
 
Back
Top