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
Split Form Duplicates Last Entry in Datasheet
-
- 3StarLounger
- Posts: 366
- Joined: 12 May 2010, 06:49
-
- Administrator
- Posts: 78238
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Split Form Duplicates Last Entry in Datasheet
I can't reproduce the error. Does this problem occur in all split forms or in one specific form only?
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 366
- Joined: 12 May 2010, 06:49
Re: Split Form Duplicates Last Entry in Datasheet
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
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
-
- Administrator
- Posts: 78238
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Split Form Duplicates Last Entry in Datasheet
If the problem persists, I'd create a new split form.
Best wishes,
Hans
Hans