If I come into my form and it is filtered then I have the code below to remove the filter and go to the previous record. i have the same for a next record button. But with the way i have it now then the form gets a flashing as it is doing its thing through the coding and you even see it go back to the first record and then back to the bookmark and then to the previous record.
I truly would like for it to just remove the filter and go to the previous record smoothly. I know we all want something :)
So is there a way to make this look more pleasing to the eye?
I would like to keep it simple and smooth. Thanks for the help!
Private Sub btnRecordSKUPrevious_Click()
If Me.FilterOn = True Then
If Recordset.BOF Then
msgbox "At The Beginning. Now Going To Last Record.", vbInformation, ""Information""
Dim intID As Variant
Dim rs As Object
intID = Me.SkuID
Me.FilterOn = False
Set rs = Me.RecordsetClone
.FindFirst "[SkuID]=" & intID
Me.Bookmark = .Bookmark
If Recordset.EOF Then
msgbox "At The End. Now Going To The First Record.", vbInformation, "Information"