Split form refresh

[uncletreetrunk]

I have a split form and a button that updates another table.

After it updates, it deletes the record.

Is there a way to "refresh" the split form so it doesn't have the #DELETED# in the record?

Manually closing and reopening it works, but when I tried coding it I got an error because the record was gone.

Thanks!

[pbaldy]

I've never used the split form, but does

Me.Requery

work?

[Missinglinq]

I've never used the split form, but does

Me.Requery

work?

Yes, it does! After all, you're dealing with a single RecordSource, which is what is actually being Requeried.

Linq ;0)>

[uncletreetrunk]

Thanks Me.Requery worked!

Although I had to put a next record command before requerying to "refresh" the split form

[pbaldy]

Happy to help.