Need List Box Assistance

[vr]

I have a form with a text box to fill a list box.

The user wants to be able to input a value in the text box, depress enter and have it load to the list box.

Can anyone help?

 

[KF]

Use the on_exit event of the text box to set the row source of the list box. Or you could just requery the row source of the list box. Make sure you have added a parameter to your row source SQL statement or query based on the entry made by the user into the text box on your form. For example, Forms!frmYourFormName!txtYourTextBox.

Good coding,

 

[jhowley58]

When the after_update event fires for the text box, edit and update the record set rowsource for the list box.. after that do a requery on the listbox.

John