well, presumably the subform's RecordSource is a query or SQL statement that
uses some criteria (perhaps something like "CompletionDate 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!MainFormName!PrimaryKeyField
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****@earthlink.net> wrote in message
news:gO****************@newsread3.news.atl.earthli nk.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
