I’m making a form in Access that is based on a query. Users should be able to enter/edit data in 2 fields via the form. The problem is that I need to use DISTINCT to clean up the list that users see.

DISTINCT was applied to a Make-Table sub query and the resultant temp table was then connected to the table with the data that needs editing (in the query that the form is connected to).

I’m new to this and was thrilled that things were working until I realized that the list shown in the form would not update unless I manually triggered the Make-Table sub query. Then I realized that even that didn’t update it for other users. Dead end!

Please tell me there’s a way to do this. What would you recommend?