Query, Form, Report No Work!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that uses a combo box for the result. Or at least it is
supposed to. I have the code: forms!myForm!comboname as my constant in my
query.

Then when I select my info from my combo box on the form then click my
button to preview my report is fed from this query and the report it is not
returning any results.

Any idea?


I can send a small copy of db to view for helping.
 
Tony said:
I have a query that uses a combo box for the result. Or at least it is
supposed to. I have the code: forms!myForm!comboname as my constant in my
query.

Then when I select my info from my combo box on the form then click my
button to preview my report is fed from this query and the report it is not
returning any results.

Any idea?


I can send a small copy of db to view for helping.
Click to expand...

I'm not sure what you are trying to do, but this example may help.

I defined a Table, [Table1], containing only one record, to give the
Query something to count.

I gave the [comboname] combo box the following properties:

[myForm]![comboname] properties:

Row Source: "Tom";"Dick";"Harry"
Bound Column: 1
After Update Event: M_Update

and the [M_Update] Macro contained these actions:

[M_Update] Macro Actions:

Close: Query Q_MyQuery
OpenQuery: Q_MyQuery, Datasheet View

The query is defined as shown:

[Q_MyQuery] SQL:

SELECT [forms]![myForm]![comboname] AS [Value]
FROM Table1;

and after I select the value "Dick" in [comboname], the value is visible
when I next open the Query:

[Q_MyQuery] Query Datasheet View:

Value
-----
Dick


-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Back
Top