I see #Delete in the fields on a split form....what would that mean.

[Pack10]

I have a split form that is bound to a table. The table gets populated from a mailbox. Simple routine that first deletes the records in the table, then reads from the mailbox and does an addnew bringing the record into the table.
This is invoked from a command button. Sometimes I see #Deleted in the fields in the split form after the routine is complete.
Any ideas on why we see that. If I close the form and re-open it, then I see all the records.

Any ideas.

 

[TheAceMan1]

How are ya Pack10 . . .

When a record in the recordsource of an [blue]open bound form[/blue] is deleted by code or some external source, [blue]#Deleted[/blue] is what you see (can't display whats not there). You need to [blue]Requery[/blue] the form ...

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[Pack10]

got it thanks.