Recent content by LinaRose

This is where I keep running in to problems. I did exactly as you said above. I have the parameters set to pull from the form and the combo box. After I set those parameters the combo boxes stop displaying data. Completely baffled.

The parameters work when I open the report and the query. I think the issue is with pulling the data from my form. I tried setting the Record Source to the query and that didn't seem to work. Thanks again for all your help I really appreciate it!

No. I did figure out that the problem occurs when I put the parameters in the query though. Without the parameters the information shows up, but the report doesn't display the correct data

I can't. It has sensitive information on it. Thanks though!

No it's not in design mode. When it's in form view I can choose a Job but not the month

Well it was working but now in my dialogue box the Month options aren't showing. The parameters work in the query and in the report but the different months are not showing in the dialogue box. I don't understand it worked just a second ago

AHA! I figured it out! I put the parameter in the wrong field. :p Thank you so much for your help it's finally working!

I have two parameters though and when I entered both in an error message popped up and said it was too complicated :mad:

Well thank you that was very specific, except I think I'm entering it wrong because it's not working. I changed the variables and it's still not working. :( The error message says there is a syntax error and there are missing operators. I put everything in exactly aligned with the variables I...

Thank you! Wouldn't I need to enter a filter name also? I am using a dialogue box to open a report based on a specific job and month. My task is to build a report that displays monthly job costs. I have an unbound combo box for both the job and the month in the dialogue form so how would I...

Thank you! My report is already based on a query. Should I just add a field that requires me to enter information as a parameter? Or do I enter the parameters under query design?

Could you be a little more specific about the "where statement"? I'm still pretty new to the VBA and macros.

Hello, I am using a form to filter information so that I can open a report. The report displays information pertaining job costs. Each month the company I work for records their labor, costs, and travel in a form with a year to date amount. Right now, I am having a problem opening up a report...

Hello, I am using a form to filter information so that I can open a report. The report displays information pertaining job costs. Each month the company I work for records their labor, costs, and travel in a form with a year to date amount. Right now, I am having a problem opening up a report...

I'll explain the order of this business: First it starts with customers. For each customer they may have several contracts. Each contract has a certain number of jobs. We issue monthly invoices to the customer for each job. Each job has a budget so each invoice needs to reflect year to date...