combo update a list box (1 Viewer)

[Kevin_S]

Hi Everyone,

I am having a problem with using a combo box to update a list box on a form:

I want the user to be able to select a value in the combo and then have the list box display all of the records associated with the combo box value selection. After the list box displays the selections I want the user to be able to select a value from the list box and have the current form move to the selected record. I have looked through pages and pages of previous entries and Access books but I can't find any workable solutions.

Any and all help is appreciated.

Thank you -Kevin

 

[Rich]

Requery the listbox on the after update of the combo
Me.MyListbox.Requery

 

[Kevin_S]

Thanks for the quick reply Rich

Follow-up Question:

How do I link the two then? i.e. how do I set up the list box so that when I run the after-update event it transfer the correct information?

- Is the list box based on a query?

- Once the correct data is displayed, how do I force the form to move to the selected record?

Thanks Rich, -Kevin