John,
1) Did you change the active table when you inserted the value?
2) Did you try adding Refresh() after the Requery()?
3) Check the code called when you move to another page and return to the page with the listbox. (Select specific table, call validation, etc.)
HTH
Barbara
>Hi,
> Why mylistbox become enabled or no effect when clicked after I insert value into the relevant table? It works back if i jump to other pages or form and back to it. I have issued requery() after insert. Any suggestion?
>
>Thank you