Jumat, 04 Maret 2016

[MS_AccessPros] Requery datasheet

 

I’m using Access 2010 and have a question about refreshing a datasheet form.  I’ve created a checkbox in the datasheet (for each record).  This checkbox is setup to remove a record from the datasheet.   I’ve created an event to requery the datasheet “after update” of the checkbox.  This removes the record from the datasheet.    Here’s the event:

 

Private Sub Check13_AfterUpdate()

Me.Requery

Form_Completed.Requery

End Sub

 

The event works fine.  The problem I have is that if I’m working in the datasheet and am scrolled down to the bottom of the datasheet, if I click the checkbox it will requery the datasheet, and focus moves to the top of the datasheet again.  Is there any way to requery the datasheet but stay in the same position on the form?  It’s annoying to have to scroll down again after every update. 

 

Any ideas?

 

Thanks,

 

Troy Sherven

__._,_.___

Posted by: Troy Sherven <tsherven@mcd.net>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar