Show query results in form

  • Thread starter Thread starter KRR
  • Start date Start date
K

KRR

So I have a combo box listing all the queries in my database. When I choose a
query and click my [Run Query] button I'd like the query to display within a
sub form I have below the combo box.

I have it working right now writting the query results to a list box in my
sub form but I can't edit any of the data.

What I'd like is the full query view to show within my sub form so I can
edit/sort etc.

Thanks,
Ken
 
So I have a combo box listing all the queries in my database. When I choose a
query and click my [Run Query] button I'd like the query to display within a
sub form I have below the combo box.

I have it working right now writting the query results to a list box in my
sub form but I can't edit any of the data.

What I'd like is the full query view to show within my sub form so I can
edit/sort etc.

Thanks,
Ken
Click to expand...

Set the Form's Recordsource property to the name of the query in the
AfterUpdate event of the combo box.

Note that only Select queries (not action queries, such as update or
make-table queries) return records, and that some of your queries may require
parameters (which might or might not be available).

This seems like a VERY VERY strange thing to do.
 
Thanks John but I don't understand how this will work. I can set the record
source easy enough but how do I get the the form to show anything when it
doesn't have any fields defined on the form?

The reason I want to do this is to allow my users to have access to the back
end end data for data-cleaning purposes without having to give then access to
the database window.

---Ken

John W. Vinson said:
So I have a combo box listing all the queries in my database. When I choose a
query and click my [Run Query] button I'd like the query to display within a
sub form I have below the combo box.

I have it working right now writting the query results to a list box in my
sub form but I can't edit any of the data.

What I'd like is the full query view to show within my sub form so I can
edit/sort etc.

Thanks,
Ken
Click to expand...

Set the Form's Recordsource property to the name of the query in the
AfterUpdate event of the combo box.

Note that only Select queries (not action queries, such as update or
make-table queries) return records, and that some of your queries may require
parameters (which might or might not be available).

This seems like a VERY VERY strange thing to do.
Click to expand...
 
Thanks John but I don't understand how this will work. I can set the record
source easy enough but how do I get the the form to show anything when it
doesn't have any fields defined on the form?
Click to expand...

Oh... sorry... should have said. A Datasheet form would be the only practical
option if you can't define the query's structure ahead of time.
 
But when switching from query to query do I not need a way to clear the form
of all previous fields and recreate the fields for the new query so they'll
show up in datasheet view?

Thanks,
Ken
 
But when switching from query to query do I not need a way to clear the form
of all previous fields and recreate the fields for the new query so they'll
show up in datasheet view?
Click to expand...

Ummmm...

did you try it?
 
Back
Top