Sometimes my form is not showing newly imported records...

[Pack10]

I am looking for the best way to do this.
I have a split form that is bound to a table.
The table contains emails from an Outlook mailbox.
Every 5 minutes, I delete the records in the table and import new records
from the mailbox. So I have a For Each Message In TheMailBox Construct
with an .AddNew and the .Update.

Sometimes, the mailbox is not refreshed and we see #Deleted.... the user has to
close the form and re-open to see the records. Its a little flaky....
Is there something I have missed or is there a better design.

Thanks

 

[missinglinq]

You need to Requery the Form, not Refresh it, after the new Records are imported.

Refreshing Records only updates the data that already exists in your Form, it does not display New Records or remove Deleted Records.

Linq ;0)>

The Missinglinq

Richmond, Virginia

The Devil's in the Details!