listbox woe's

[bradwould]

I have a form with a listbox in it. the list boxed is used to select an item to view in the sub form. All is well except when i try to add an item to the list box. I have set up a macro to enter new data in the list box by opening the table that supports it and entering the new data. what i need is for the list box to update and show the new information entered automatically. as of now i need to close the form and reopen it to view the changes.

thank you

 

[Bat17]

You need to requery the listbox. Do this from code after updating the list.

me.mylistbox.requery

HTH

Peter

 

[bradwould]

thanks

your suggestion worked partially. the list box does update ...but only after another item is selected. is there any way to update the first time you click on the down arrow of the list box? Onclick doesnt seem to work

 

[Bat17]

it should update straight away! You could try a Me.Repaint after the requery to see if that will show up the change.

Peter