Search results

I really need some input on this guys If you could suggest anything, my deadline for this is coming up pretty quick and I'm lost on this

Ok, so I have a Report that is filtered by several combo boxes on my main Form. What I want is to change the value of a text box on a sub report on the main Report. The sub report that this combo box is on is either visible or not visible depending on the selection in the combo box. I have this...

I'm still having difficulty with part of the report. I tried putting that code in the "Filter" box of my subreport. It does affect my overall total text box which has the sub total box incorporated in it's sum but the change in the overall total is not the same as the sub total itself from this...

Thanks for your reply JoeComputer, but I figured it out FINALLY!! What I had was the code on the On Open event of the sub report. So was I did was move this coding onto the On Open event of the main report and now it works wonderfully

ok update I think I got the code right Private Sub Report_Open(Cancel As Integer) If Forms!frmInvoice!cboTankType = "Sour" Then rptCoating.Visible = True Else rptCoating.Visible = False End If End Sub but I get a "Run Time Error: 424" when it runs any suggestions?

/bump anyone, anyone at all

If anyone can help me with the syntax of this if statement that would be great. It's kind of a priority

is the syntax for this correct? it seems to be having trouble compiling it :(

I really need an answer to this guys or even if it's possible if anyone can help me

I don't think this will work for me see, there are some subtotal text boxes on these subforms that contribute to a final total box on the main form if they are simply invisible, their totals would still appear in the final total would it not?

Hey guys, I have a main report with several subreports on it that are filtered by a form with several combo boxes on it What I would like to do is have some of the sub reports only open on the main report depending on the input in the combo box ie.if the user chooses "Yes" from the 'Heated'...

it gives me "Compile error: Variable not defined" and highlights "viewtype"

hmmmm, it seems be having trouble with the "viewtype" variable

excellent thank you d00ku, I will see if I can work this out with what you've given me

ok so if I wanted it to go off something other than "yes" or "no" but to choose from 2 selections but I want it to run in a similar manner. how would I go about doing that?

What does the "-1" stand for?

ok nevermind, I misread what you typed this is what I'm looking to do, but I don't know the coding as I've had no experience with VBA. If someone could help me out with it that would be great I would assume it would be an If/Then type statement

that's not quite what I'm looking for the combo box will be updated no matter what. In the combo box will be a Yes/No type selection, and based on this input, I want it either run, or not run the query

Hey guys I was wondering how I would go about making it so that a query will run or not run based on the input from a combo box. I have a form with several combo boxes. And a couple of these controls a query that I would like to be optional. Right now it runs no matter what the input in the...

Ok, I figured a work around for it. What I did was created a unique subform for the options data which I pretty much just copied from your sample RG Thanks again for all of your help and patience. :)