i have a form with member information and a subform for the notes.
when the user opens the form, it will have the member info and the notes. i want those notes to be sorted by date descending. i know i can do that by basing the subform on a query.
the problem is:
i want the user to be able to add a note. she would click the >* button on the bottom to get a new record and enter the note. i want the date to be filled in automatically - either by default of the note_date field or as an afterupdate on the note field.
it seems that i can't have both the sort descending and the automatic date.
what can i do?
when the user opens the form, it will have the member info and the notes. i want those notes to be sorted by date descending. i know i can do that by basing the subform on a query.
the problem is:
i want the user to be able to add a note. she would click the >* button on the bottom to get a new record and enter the note. i want the date to be filled in automatically - either by default of the note_date field or as an afterupdate on the note field.
it seems that i can't have both the sort descending and the automatic date.
what can i do?
