Filter month on report using combo box from form

[chuki2]

Hello all....Im new here...



I have create accounting form,the problem right now is Report can`t filter using combo box..

So how i can figured out?

[alansidman]

What is the record source for your report? It should be a query. Have the query criteria for month field be driven by your combo box.

You will need something like this in your criteria

=Forms!YourFormName.YourComboBoxName

[chuki2]

Hye...thanks for reply...

Yeah....my report soucre come from table....Is called tblAcc

So i need to create query?how i can link query to report?

[alansidman]

With your report open in design view, click on the properties for the report. Go to Data Tab and change the record source to the query. Now do the same for each of the fields in your report so that the data is coming from the (filtered) query and not the table.

Alan

[chuki2]

Owh i see....that means,i need create a query from table right?

How about combo box?how i can make start from January 2011,February 2011 depends on record?

Thanks for reply....

[alansidman]

Look at this and set it up with a combo box.

http://www.datapigtechnologies.com/f...earchform.html

and this one.

http://www.datapigtechnologies.com/f...tomfilter.html

[chuki2]

Hello mrs alan....

I can`t filter the query using combo box...i have follow the toturial but i got same problem...

query filter can apply on date?

I want to filter month and year only....

If need use date part,how to apply it?

Thanks for help mr allan....

[alansidman]

You are not giving enough details for an explicit answer. Perhaps if you posted your db with sample data. Then using your db, ask specific questions. And post what your expected results are. Currently, we are dealing with generalities.

[chuki2]

Ok im sorry....

Hehe,i can make it....successfuly...

Thanks alot friends...

[mk118]

What is the record source for your report? It should be a query. Have the query criteria for month field be driven by your combo box.

You will need something like this in your criteria

=Forms!YourFormName.YourComboBoxName

tanks
very tanks


for combo12 in criteria on query
[forms]![tbl1].[combo12]
for date in criteria on query
>=[forms]![tbl1].[text18] And <=[forms]![tbl1].[text20]

problem is solved
very tanks