Need help with report filter! Anybody?

[efi]

Hello everyone!



I am Efi and I have been trying to build a database for the last 2-3 weeks. It is a database with products, clients and orders. I must say that I don't know much about access. I had taken a seminar about 12 years ago and that was it. I am really excited, though, trying to build this db. I am enjoying it very much.
Now, what I want to do is filter a report. To be more specific, I want to enter the name (or part of it) of a client and push a button (maybe... not necessary) to open an existing report that will then be filtered and show the results I requested. I'm sure it is easy for you. The thing with me is that I have no idea of VBA or macro design.
So, what do you think?

Thanks in advance, guys!

[amrut]

Start learning VBA, it is not that tough
Also all the help is available in VBA Editor too. Press Alt + F11 to open the editor and use the search box in top right corner
See below for details
http://msdn.microsoft.com/en-us/libr...ice.15%29.aspx

[mahonealex018]

I am learning it, that is why i have joined this forum.

[aytee111]

You don't need VBA to accomplish this. The clients will be in a combo box on the form, the user selects which one they want to run the report for. Then in the "Record Source" of the report you include a criteria of the client = "Forms!formname!client"

[efi]

Thanks a lot everyone!!!

@aytee111. I understand what you are telling me to do, but I can't get it to work. :-(
I have created a report, based on a query, that gives me all sales grouped by client and then by date. I am trying to use this one. Is there something different that needs to be done in this occasion?

[aytee111]

Did you put the form client name in the criteria of the query?

[aytee111]

You could also put the filter on when you open the report from the form: DoCmd.OpenReport "rptname",acViewPreview,,"clientfield='" & me!clientbox

[efi]

You could also put the filter on when you open the report from the form: DoCmd.OpenReport "rptname",acViewPreview,,"clientfield='" & me!clientbox

I tried this one and I get: Run-time error '3075': Syntax error in string in query expression 'ΕΠΩΝΥΜΙΑ='ΓΙΩΡΓΟΣ'.
(ΕΠΩΝΥΜΙΑ is the Client Name field and ΓΙΩΡΓΟΣ is a client's name.
Any ideas what I'm doing wrong?

[aytee111]

There don't seem to be the right quotes = "clientfield='(single quote)"(double quote) & me!client & "'" (double,single,double)

[efi]

You are so right!!!!! The report opens now. It does not return any results for the client I'm requesting, but maybe it's because of the relationships I have created. I'll check it and get back to you. If anything comes to your mind on that, let me know... :-)
Thanks a milion aytee111!!!

[efi]

Problem solved aytee111!
Thanks a lot!!!!