Query, Update

[Rick Cass]

I would like like to have a query run, against
tblCustomers, and get a list of the customer names and
then update a listbox values on the form.

Can someone tell how to perform this?

Thanks,
Rick Cass

 

[Ken Snell]

Maybe I'm not understanding, but you can use this query as the row source of
the listbox. No need to do something separately. If you want to "refresh"
the list after something has been added to the tblCustomers, just use code
to do a Requery on the list box:

Me.ListBoxName.Requery