G
Guest
I'm using Access 2003 and have created a form with several subforms and
everything works fine. The subforms display in datasheet format.
I've been asked if I can modify the main form slightly to display the most
recently entered data in the subforms on the main form. I had thought about
using a query but am not sure how I should set it up. Not all of the
subforms have a date field but they do all have an autonumber field. I can
use a query to sort by autonumber in descending order, but how do I specify
that the (now) first entry in specific fields are the ones that I want to
display in specific text boxes on the main form?
Thanks for any solutions.
everything works fine. The subforms display in datasheet format.
I've been asked if I can modify the main form slightly to display the most
recently entered data in the subforms on the main form. I had thought about
using a query but am not sure how I should set it up. Not all of the
subforms have a date field but they do all have an autonumber field. I can
use a query to sort by autonumber in descending order, but how do I specify
that the (now) first entry in specific fields are the ones that I want to
display in specific text boxes on the main form?
Thanks for any solutions.