Textbox Only ?

[DS]

I have this code that works with a Textbox.
When I try to use it with a Listbox I get the 424 Error Object Required.
Does this code have to changed, if so to what. Or am I barking up a
wrong tree?
Thanks
DS

If Me.ListGroups.Column(4) > 0 Then
Me.ListGroups.Column(4) = Me.ListGroups.Column(4) + 1
Else:
End If
Me.ListGroups.Requery

 

[Wayne Morgan]

You will need to change the value in the listbox's Row Source data source
then requery the listbox. You won't be able to make the change directly in
the listbox itself.

 

[DS]

You will need to change the value in the listbox's Row Source data source
then requery the listbox. You won't be able to make the change directly in
the listbox itself.

Thanks Wayne, I would need an SQL Update statement.
DS