Re: Remove Rows in a List Box after fields are updated

? Once the data is entered thru the text boxes, is that the critieria that
will eliminate them from the list box? If yes, then perhaps a
Me.NameOfListBox.Requery on the OnExit of the text box that has been updated
will accomplish what you need?

By requerying the list box, if that is the criteria in query then it should
disappear from view.


"j1eggert" <j1eggert@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8F567EB2-27AD-460D-BA74-3040A65B245D@xxxxxxxxxxxxxxxx
>I have a form that I use to automatically list specific fields in a list
>box
> that need to be updated at a later date. Two text boxes are used to enter
> the
> data in and then are updated by clicking a command button. I need two
> things
> to occur when this process is complete, automatically update the fields in
> the list box and remove the row automatically once it has been updated.
> With
> my time constraints I do not want to write code, if possible. However, if
> their is no other way to accomplish this task let me know.
>
> Sincerely,
> James E


.

Loading