I only have very basic knowledge in Access so please bear with me. I have a form that has an unbound text field and it uses VB Script to pull filtered results from a query. When the query is just a plain Select query I am able to type into the unbound field in order to pull the filtered results. The query has duplicates which I want to eliminate from the results so I made this a SELECT DISTINCT query to do the filtering. I figured this would be easier than cleansing the data. However, after making the change I can no longer enter data into the unbound field. (Grouping doesn't work either) Need someone to offer suggestions.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search function on form not working when using DISTINCT query
- Thread starter mmmgood
- Start date
kermit01de
Technical User
Try to do a "header - detail" solution. Select a header from a list, display the detail (simple SELECT) - update the detail.
--------------------------------------
>>>>>> Bugs will appear in one part of a working program when another 'unrelated' part is modified <<<<<
--------------------------------------
>>>>>> Bugs will appear in one part of a working program when another 'unrelated' part is modified <<<<<
- Status
Similar threads
- Locked
- Question
