Posted on 1997-09-05
Using an unbound main form and unbound subform, a passthru query is used to pull records back from an Oracle Database via ODBC connections. The criteria for the query is taken from the unbound main form. The query runs great by itself and displays two records in a datasheet.
However - trying to get those records into an unbound subform (using no source) results in the same record being shown twice. Clicking on the record selector shows the second record twice - but neither at the same time!
Trying to use the passthru query as the source results in an error message saying that columnheadings are required. Yet that is part of a crosstab query - not a passthru!!!
Advice please. Is it possible to use a passthru in a subform - bound or unbound?
How can I get the records to be displayed in datasheet format within a main form - preferably avoiding list boxes, etc.?