Need help on how to update a list box immediately after entering data in a text box!!!

[NKB]

I hope somebody can help on this.



Simply, I have a List box (lboTitles) in a form; its list items are pulled from a table via a query, and a bound text box (txtTitle). When a user enters text in the txtTitle text box, I want my Afterupdate event procedure txtTitle_Afterupdate to immediately update the list box (lboTitles) showing the newly entered title in the txtTitle. Currently all I have in the txtTitles_Afterupdate() is : me.lboTitles.Requery. Guess what! it is not working. I have tried and tried but no luck. Experts please help. Thanks.

[pbaldy]

The textbox is bound to the table the listbox uses? You probably need to save the record first:

If Me.Dirty Then Me.Dirty = False

[NKB]

More clarifications: If a user selects an item in the list box lboTitles and he enters a text in txtTitle, then I want the code to immediately update the selected list box item to reflect the new change. I am not adding an item but changing the text of a selected item. That's all I want to do. How to do it? I do not know

[davegri]

try:

txtTitles_Afterupdate()
me.requery   
me.lboTitles.Requery

[pbaldy]

Is the form bound to the same table? You can use the listbox or combo wizard to make the form go to the selected record, and let the user change the value.