Display query results on user form

[Ganesh7299]

Hi Experts,



I have just started with MS access and seeking for help for the same on below issue.

I have created form and would like to display query results on form (in textbox), which is executed based on combobox change event on the same form.

Thanks in advance,
Ganesh

[ItsMe]

The usual approach would be to bind a form to a query and then filter the results via the combobox's value.

It is hard to understand what you want to do. Perhaps a main form with a combo and a subform dependant on the combobox is appropriate.

[Ganesh7299]

I have fond the solution as below for displaying query results in the textbox.

created query name as "comm"

SELECT Sum([FYE 2013].[Jan 2013]) AS commu
FROM [FYE 2013]
WHERE [FYE 2013].[site] =IIf(Forms!Form1![site]="All","'*'",Forms!Form1![site]);

then applied Dsum function in Control source property of textbox

=DSum("commu","comm")

Now I am facing problem if combobox site value is "All" then it is showing blank, as there is no record mating with "All", but i would like to display all records sum in the textbox, if combobox site value = "All"

Any help highly appreciated....

Regards,
Ganesh

[June7]

Name of combobox is site? Is site a number or text field? What is value of the combobox?

Try:

=DSum("[Jan 2013]", "[FYE 2013]", IIf([site]="All", "", "site=" & [site]))


The table and field names make me think this data structure is not normalized.