Form setup

[Guest]

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

 

[Rick Brandt]

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

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).

 

[Dirk Goldgar]

In

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.

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.