Search results for query: *

Hi again, I finally got it to work. I was making this too complicated I guess. I put the following code in the On Format Event of my MonthlyCompleteAll subreport: If Me.txtCouncil = False Then Me.Text5.Visible = False Me.Text19.Visible = False Me.Label7.Visible = False End If Thanks so much...

I comment out the 3 lines and put a message box but it doesnt go further then the 1st line. Same error. This is so frustrating !

I changed txtCouncil to a Yes/No instead of a True/False. I entered your code in the On Format Event of the Report Footer of the Main report. Here is the code: If Me.MonthlyCompleteAll.Controls("txtCouncil").Value = "No" Then Me.MonthlyCompleteAll.Controls("Label7").Visible = False...

txtCouncil is a textbox refering to a Yes/No field. And yes, you are right. The name was wrong. I corrected it to MonthlyCompleteAll and am still getting the same compile error. Am I putting the code in the right place ? Should it be on the Main report or in the subreport ? Thanks again ! Julie

Hi rjoubert, Yes, MonthlyCompleteAll is one of my subreports. I inserted your code in the Main Report's Report Footer On Print Event but I am getting Compile Error: Method or data member not found. Any other ideas ? Thanks, Julie

Hi, I have a main report(MonthlyAll) that includes 4 subreports in its Report Footer. I want to apply the following condition to one of the subreport (MonthlyCompleteAll) : If Reports![MonthlyAll]![MonthlyCompleteAll].Reports![txtCouncil] = False Then...

Duane, I finally was able to make this work with your suggestion #1. Thanks so much for your help! Have a great day! Julie

Hi Duane, Thank you for your reply. Yes, my drop down is a multi-select list box, sorry for not mentionning this. I looked at the first suggestion (since I had no idea what the 2nd suggestion ment, my Access is very basic!). When trying to insert the ...

Hi, On a form I have a drop down menu where users can multiselect Departments to include on a report. My report includes a detail section + 3 subreports in the report footer. In my OnClick, I use the WHERE clause to indicate which departments to show on the report, but the WHERE clause only...

Hi, On a form I have a drop down menu where users can multiselect Departments to include on a report. My report includes a detail section + 3 subreports in the report footer. In my OnClick, I use the WHERE clause to indicate which departments to show on the report, but the WHERE clause only...