Matthew Snook
NW Salmon Database
- Local time
- Today, 11:21
- Joined
- Apr 19, 2001
- Messages
- 133
Disregard!
Problem not solved, but I found a way around it...
OK, this is a new one on me.
I have created a form "fsub_Summary." This form uses sql as the recordsource. In most ways, the form is functional. I use it as a subform (hence the name) and I've created some code which rewrites the sql based upon some data in the parent form and then requeries the form.
Now, when I run some sql in a standalone query, I get results. For instance one version returns 18 records, with averages, group by clauses, etc. When I open this form with that identical (copied and pasted) query as the recordsource, the data does not show! I get the datasheet view (when I set the view properties to datasheet) and there are 18 grey box record selectors to the left, and the record count at the bottom is 18, but the main data sheet is empty. No columns are presented.
What did I miss?
Thanks,
Matt
[This message has been edited by Matthew Snook (edited 04-17-2002).]
Problem not solved, but I found a way around it...
OK, this is a new one on me.
I have created a form "fsub_Summary." This form uses sql as the recordsource. In most ways, the form is functional. I use it as a subform (hence the name) and I've created some code which rewrites the sql based upon some data in the parent form and then requeries the form.
Now, when I run some sql in a standalone query, I get results. For instance one version returns 18 records, with averages, group by clauses, etc. When I open this form with that identical (copied and pasted) query as the recordsource, the data does not show! I get the datasheet view (when I set the view properties to datasheet) and there are 18 grey box record selectors to the left, and the record count at the bottom is 18, but the main data sheet is empty. No columns are presented.
What did I miss?
Thanks,
Matt
[This message has been edited by Matthew Snook (edited 04-17-2002).]
