Requerying a Listbox

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a form with a list box containing Clients names and a button taking
you to a form with further details. The listbox values come from a query
where the checkbox value is true. The checkbox can be unticked from the form
in connected to the button.

When I untick the check box how can I make the listbox remove the clients
name automatically from the listbox. I have tried a "me.requery" and
numerous other things with no joy.

please help
 
Me.Requery requeries the RecordSource of a form, not the RowSource of either
a listbox or a combobox on the form.
if i understand you correctly, you have a form open. in the listbox on the
open form, you select a client's name. that action opens another form which
shows details about the client. when you uncheck the checkbox on the client
detail form, you want the listbox on the *other* form to requery. correct?
if yes, then try this code on the checkbox's AfterUpdate event, as

Forms!OtherFormName!ListboxName.Requery

hth
 
Back
Top