Query result illustrates results on main form

**Dave_D** · 12-01-2016, 08:07 AM

I was recently asked to modify my DB do to duplicate data being imported. I developed the necessary queries to eliminate the duplicates; all that works just fine. To execute these queries, I have been using DoCmd.OpenQuery <query name>. When it executes, the results open and appear on my main form. This has never happened to me using the OpenQuery command before. These are NON action queries. What might be causing this to open which other queries, using the OpenQuery do NOT show there results. Thanks!

**ranman256** · 12-01-2016, 08:31 AM

Select queries will ALWAYS display. Only action queries do not.

Query result illustrates results on main form

Thread Tools

Query result illustrates results on main form

Similar Threads

Displaying result from a query in a form results in "#Name? being returned

Display results on subform based on a query from the main form

Reference query results in a Main Form

Display results of a query on the main form

Update the subform with query results in a main form

Posting Permissions