Recent content by hulaman

I found the answer and it was easy thanks to all for your suggestions. Here is the fix: Firstly, what was holding me back was the criteria in the qry (from form) that the report was based on (the cascading drop down boxes). Once I removed the criteria where my selection equaled...

Thanks Pat, I think an important aspect of this (or maybe not?) that I didn't mention is that the main report (that I need to print 675 variations of) has 8 subreports that it drawns on for the data. This is because of the one to many table relationships. Each product has multiple parts with...

Hello All, I have a cascading drop down box with 4 fields which works wonderfully to produce individual reports based on a querydef written in VBA. Everything works great, I can bring up all 675 variations of the product with respective costs to produce each one. It would take a couple of...

Hello, I need to be able to have one of multiple comboboxes left blank. I have tried Is Null for one of them with no luck. I need to be able to leave one of the cbo**** choices blank. This select query works perfect except when one is left blank I get nothing back from the query. Here is the...

Thanks, I will try that and thanks for the advice on learning more about Access. It seems as an adult learning, it's On the Job Training OJT. :)

Hello All, I am new at using Access database and prefer using macros rather than VBA. That being said here is what the company wants me to do. Figure the costs of making the products, materials only, no labor, no overhead. There are multiple products with multiple pieces (about 5-10) and each...