Split Form Duplicates Last Entry in Datasheet

MSingh
3StarLounger
Posts: 366
Joined: 12 May 2010, 06:49

Split Form Duplicates Last Entry in Datasheet

Post by MSingh »

Hi,

The last entry in my SplitForm is duplicated in the Datasheet only.
I have added:

Private Sub cmdRefresh_Click()
Me.Refresh
End Sub

which eliminates the visual duplication.
Is there another way to avoid the user-input?

Neither of:
Me.Refresh
Me.Requery
Me.Recalc
Me.Repaint in the Form_AfterUpdate event
works.

Any help would be very appreciated.

Thanks again
Mohamed

User avatar
HansV
Administrator
Posts: 78238
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Split Form Duplicates Last Entry in Datasheet

Post by HansV »

I can't reproduce the error. Does this problem occur in all split forms or in one specific form only?
Best wishes,
Hans

MSingh
3StarLounger
Posts: 366
Joined: 12 May 2010, 06:49

Re: Split Form Duplicates Last Entry in Datasheet

Post by MSingh »

Thanks Hans,

It's one specific form only in the same database as FORM_~TMPCLP169771.

I added:

Private Sub cmdSave_Click()
DoCmd.Save
Me.Refresh
End Sub

This seems to work (for now, at least).

& Yes, I'll follow your advice & import into a new database.

Thanks for the very quick replies.

Kind Regards
Mohamed

User avatar
HansV
Administrator
Posts: 78238
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Split Form Duplicates Last Entry in Datasheet

Post by HansV »

If the problem persists, I'd create a new split form.
Best wishes,
Hans