I am trying to do the same process now! My end users do not want to go to EDIT-WORKSHEET OBJECT-EDIT-DATA-REFRESH DATA in Access every time they want to view new data. Did you ever resolve the problem? I would be very interested in how you did it.
Thanks so very much,
Susanne
Hi:
Have been struggling with this problem and am sure it has a simple solution. I have created a query that gives me back all the customers and their invoice totals. In that query (grid) I would like to create a combo box that when run, will list all the customers and then choose from that...
Try this:
Under the Properties of the List Box; Row Source; insert the words "SELECT DISTINCT" at the beginning of the phrase that is already there.
Hope this helps,
Susanne
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.