Form setup

A

austin

In respect to a call log database, is there a way for the form to display
only the last entry and a new entry field.
thanks
 
R

Rick Brandt

austin said:
In respect to a call log database, is there a way for the form to
display only the last entry and a new entry field.
thanks
Click to expand...

Base the form on a query that sorts on the CallDate in descending order and
then set the query to return only the top 1 record (it's in the property
sheet).
 
D

Dirk Goldgar

In
austin said:
In respect to a call log database, is there a way for the form to
display only the last entry and a new entry field.
Click to expand...

Yes, so long as there's something in the data that identifies which
record is the "last entry". For example, suppose you have a table named
"CallRecords", and each record in that table has a date/time field named
"CallDateTime", which is set to Now() when the record is saved. Thus,
the record with the maximum value in that field is the latest entry.
Given such a table, you could bind your form to a query like this:

SELECT *
FROM CallRecords
WHERE CallDateTime =
(SELECT Max(CallDateTime) FROM CallRecords);

You would need to requery the form after adding each new record.
 
Top