well, presumably the subform's RecordSource is a query or SQL statement that
uses some criteria (perhaps something like "Completion Date Is Not Null") to
display only completed records. until you save the CompletionDate entered in
the current project record, the data is not in the table, and so it can't be
pulled by the subform's RecordSource.
the closest thing i can think of is to change the RecordSource, perhaps in
the CompletionDate control's AfterUpdate event, setting criteria to
something like
CompletionDate Is Not Null Or PrimaryKeyField =
Forms!MainFormN ame!PrimaryKeyF ield
and then requerying the subform. that would give you all completed (and
saved) records, plus the current mainform record.
you'd have to contend with resetting the RecordSource back to the original
each time you move to another record, and also in the event of an Undo
command.
hth
"Melissa" <mb****@earthli nk.net> wrote in message
news:gO******** ********@newsre ad3.news.atl.ea rthlink.net...
I have a single (not continuous) form with an Undo button for entering
finished projects. On the form is also a subform that lists all finished
projects for reference. When I enter the CompletionDate which is near the
beginning of all the fields, I would like the current project to appear in
the subform which lists all the finished projects. I can't save the
current project at that point because I wouldn't be able to use the Undo button
after that. How can I display the unsaved current project in the list of
finished projects after I enter the completion date? I am open to using a
listbox instead of a subform if that would make it possible.
Thanks!
Melissa
