What event would you use to refresh a listbox after an update?

[Gurtz]

If you are talking about the user entering some data in a
text box or other control, then in the control's
AfterUpdate event, you could call the listbox's requery
function.

If you are talking about the user entering data in many
fields of a form, then the only way you will know that
s/he is done entering data is if they enter it
sequentially (then you could use the AfterUpdate event of
the last control) or if they hit a button to submit/save
the data or to move to the next record. In the latter
case, throw the requery call in the button's click event.

I don't know if that quite answer's your question. If not,
reply back and be a little more specific about your
question.

Gurtz
[email = no $]

 

[Robert Johnson]

Thanks all, I figured it out.

Robert

If you are talking about the user entering some data in a
text box or other control, then in the control's
AfterUpdate event, you could call the listbox's requery
function.

If you are talking about the user entering data in many
fields of a form, then the only way you will know that
s/he is done entering data is if they enter it
sequentially (then you could use the AfterUpdate event of
the last control) or if they hit a button to submit/save
the data or to move to the next record. In the latter
case, throw the requery call in the button's click event.

I don't know if that quite answer's your question. If not,
reply back and be a little more specific about your
question.

Gurtz
[email = no $]

-----Original Message-----
Hi all. What event should I use to fire the code Me.Listbox.Requery after
my user has updated a row from a form?

TIA

Robert


.

 

[Robert Johnson]

Thanks all, I figured it out.

Robert

If you are talking about the user entering some data in a
text box or other control, then in the control's
AfterUpdate event, you could call the listbox's requery
function.

If you are talking about the user entering data in many
fields of a form, then the only way you will know that
s/he is done entering data is if they enter it
sequentially (then you could use the AfterUpdate event of
the last control) or if they hit a button to submit/save
the data or to move to the next record. In the latter
case, throw the requery call in the button's click event.

I don't know if that quite answer's your question. If not,
reply back and be a little more specific about your
question.

Gurtz
[email = no $]

-----Original Message-----
Hi all. What event should I use to fire the code Me.Listbox.Requery after
my user has updated a row from a form?

TIA

Robert


.