Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Cut and paste macro for listbox contents not working

So i have reviewed what i previously had and changed things around a little. I have progressed a little by referring back to previous help Etc. So uploaded is same database V1.13 Here I now have the form ECNListByCustomers added. So when i open the form without touching the customer listbox i have a full list of ECN data in the ECN List listbox. After pressing refresh this updates the subform in accordance with the chosen ECN. I can then add PartNumber and Description. However I would like to filter the ECN List listbox depending on the Customer chosen. I have tried to edit the previous macro but the best i can achieve so far is for the ECN List listbox to clear. I feel I am very close but no matter how much tinkering i do with the macro i cant manage to get it to work. I did add a second refresh box in case it was a refresh problem but no joy so removed it for now. I would also like to have the current refresh box removed but happy to stay with it until immediate issue is resolved

Cut and paste macro for listbox contents not working

So i have reviewed what i previously had and changed things around a little. I have progressed a little by referring back to previous help Etc. So uploaded is same database V1.13 Here I now have the form ECNListByCustomers added. So when i open the form without touching the customer listbox i have a full list of ECN data in the ECN List listbox. After pressing refresh this updates the subform in accordance with the chosen ECN. I can then add PartNumber and Description. However I would like to filter the ECN List listbox depending on the Customer chosen. I have tried to edit the previous macro but the best i can achieve so far is for the ECN List listbox to clear. I feel I am very close but no matter how much tinkering i do with the macro i cant manage to get it to work. I did add a second refresh box in case it was a refresh problem but no joy so removed it for now. I would also like to have the current refresh box removed but happy to stay with it until immediate issue is resolvedC:\fakepath\Project Tracking Test V1.13.odb