I have a table in Access that contains purchase order records for multiple departments. I would like to pull records through to Excel and display them in a semi-editable list/grid. My idea for the selection of which data to pull through would be by using two combo boxes. The first box would be for department and the second would be for unique purchase order numbers that are specific to the department selected (both fields are on each record in the table). Then based on these two combo boxes, the PO data would be displayed in the list/grid allowing one of the fields to be edited and then written back to the Access table
Is this possible, and if so, could someone point me in the right direction to get started
Many thanks
Andrew.