form doesn't populate by query results!

[accesslessio]

I have a form divided into tabs. One tab contains a spreadsheet view sub-form and a textbox above the subform. The subform has the record source set by the query 'tests' results. The criteria of the query reads the information wrote in the textbox. Everything is fine, but, as I run the query instead of populating me the subform it opens me an access tab with the query results (the same that opens when you run a query by double clicking the query name on the list on the left menu. How can I make the query populate the form instead of opening a tab in the access main window?

[CJ_London]

as I run the query instead of populating me the subform it opens me an access tab with the query results

how are you running the query? and how are you apply the criteria?

[accesslessio]

I'm running the query by clicking a button that runs a macro. The macro has the instruction OpenQuery. The criteria is [form]![MacroAttività]![testo493]. The query works but it opens me a query tab with the result listed in a spreadsheet view (as normally done when you double click the query in the left menu)

[CJ_London]

the clue is in the name of your command - openquery. I don't use macros, so no idea what the macro way might be (assuming it is possible). I'm surprised at your criteria - how does the query know which field to apply the value to?

If this is a web database then I guess you are stuck with macros.

Assuming your subform has its recordsource set to the query, then instead of applying the criteria to the query, you would apply to the subform filter.

[accesslessio]

the clue is in the name of your command - openquery. I don't use macros, so no idea what the macro way might be (assuming it is possible). I'm surprised at your criteria - how does the query know which field to apply the value to?

If this is a web database then I guess you are stuck with macros.

Assuming your subform has its recordsource set to the query, then instead of applying the criteria to the query, you would apply to the subform filter.

It's not a web db. What do you mean apply the criteria to the subform filter. You mean the criteria of the query? that one is set to the textbox493 in order to receive user input. How do I set to the subform filter? Maybe I didn't understand.

[CJ_London]

Assuming your subform has its recordsource set to the query, then instead of applying the criteria to the query, you would apply to the subform filter.

at the moment I'm assuming you have a query called say 'Query1' and in the after update event of your testo493 control you are using openquery.

In vba this would look something like

docmd.openquery "Query1"

instead try

mysubformcontrolnamehere.requery

[accesslessio]

I did it but it displays only an emtpy frame instead of the subform. I really don't know what going on..I'm very pissed. It's been more that 3 hours that I'm working and on a combobox that populates a table where itself takes the listed values. On the web I find poor references and old tutorials.. Only forums helps me get out..

[CJ_London]

It's been more that 3 hours that I'm working and on a combobox

thought you were talking about a textbox

suggest compact and zip your database and upload here. remove all forms, queries, tables etc which are not relevant.

[accesslessio]

thought you were talking about a textbox

That's another work I'm on

suggest compact and zip your database and upload here. remove all forms, queries, tables etc which are not relevant.

here. The control is textbox 494 in the form MacroAttività, tab 'lista progetti/attività'
Where do I upload the file?

[CJ_London]

click on the 'go advanced' button next to the 'post quick reply' button. You'll see the options there