Excel & Access

[talytech]

I have an excel form with a button that updates an Access database table with the information on the form. I want to be able to filter the access database from the excel form and have a pop up form display the data from the access database. Is there a way I can do that?

[stevebriz]

How you do it exactly depends on how you want to do display the data and whether you want to be able to edit the data in the form.
Do you want to use something like a MSflexgrid?? or something else???

[talytech]

I'd like to use a list box. For example:

1. From the button (myfrm.show)
2. show the user form with a list box where the columns to the list box are fields from the access database and the rows is data from the access database.
3. select a record from the list box and update the access database