Requery on checkbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an option group with a series of 5 checkboxes, and each time the
selection changes, I want to requery the database which in turn, will sort
all the records based on those 5 checkboxes, yet the following doesnt work :-

Private Sub groupMembership_AfterUpdate()
Me.Requery
End Sub

I cant alter it to BeforeUpdate() or Click() because of the nature of the
Requery code i want to run.

Anyone have any idea ?
 
Hi,


Requery tries first to save the actual record (if it is dirty) and then,
re-execute the query that support the source of the form, leaving you on the
first record of the new "recordset". "Doesn't work" does not tell much
about where it fails? it does not what you expect (but may do exactly what
it should)? or there is an error?




Vanderghast, Access MVP
 
Back
Top