Recent content by fire2ice

First, how would I write the If statement to check whether there are records on the subform? Second, the three activities are all different. A little more info about the database follows: Table for main form: tblObjectives Table for subform: tblActivities PK on main form: ID (autonumber) FK...

I have a subform that tracks multiple activities for each objective. However, one of my objectives always has the same three activities. What I want to do is, from the click of a checkbox (with the value = True), create the record for activity 1 and put specific text in the activity field...

The advice was in no way bad. You helped me think things through. I truly appreciate your help. :)

I figured out why the On Format event wasn't triggering. 2007 has an additional report view than prior versions. I am looking at the report in this new view. When I open the report in Print Preview, the code fires. I guess I'm going to have to have the report open in Print Preview instead of...

I put the code in the On Click property of the section of the report with the control...and the code works fine there. For some reason, the On Format event just isn't firing when the report is opened.

I went one step further and created an unbound textbox with a brand new name. It had a calc making it equal to the original calc control. I used this in the reference and it still didn't work. It feels like I'm trying to breathe through a straw...a very small straw. That feeling is one of...

Me too. It's odd that it doesn't even execute at all.

I created a blank database, turned AutoRename off, and imported everything into the new database. This didn't help. It was worth a shot though. I think that because this database is only a week old and I never had to change the name of any fields in the tables, that there wasn't much chance of...

Because the code doesn't give me an error when I put it in the On Format event of the section where the calculated control is, I decided to debug the code there. I put a breakpoint in and oddly it doesn't seem to even be firing.

This is a report, not a form. I've tried all three ways (Me. and Me! and no Me). There is a Case Else statement which makes all the rectangles not visible.

Runtime Error '2424' The expression you entered has a field, control, or property that Microsoft Access can't find. Using the variable didn't do anything.

Not bad at all.

I didn't preview my post and noticed after I posted that it was messed up. It seems that we both reformatted it at the same time. LOL

I am trying to have certain rectangles become visible or not based on the value of a calculated control in a report. However, it gives me Error 2424 and points to the calculated control Me.calcOverallRating as the problem. The control is available in the list after I type Me. and therefore is...

The final solution to this issue was some well placed quotation marks. = """" & DLookup("[DateYear]", "tblReportYears", " right([DateYear],4) ='" & Year(Now()) & "' and" & "[FiscalCalendar]='" & "Fiscal" & "'") & """"