Search results

I'm working on a formula for a control source on a checkbox on a form. I have this formula =IIf([OPBalanceDue]="$0.00",[OP Recovered]=True,False) I'm trying to say if this OPBalanceDue field = $0.00 dollars then OP Recovered field/checkbox should check which would = True, and if not then...

Is it possible to pull a calculated field from one report into another report. I know you can set it to sum as =[Reports]![Levels of Access Rpt]![AccessRating] or something like that it should identify that field in that report but I get ERROR# or can you take a calculated field and get it into...

I'm trying to combine three calculated fields into one field that will total all 3.The trick is only one of the two fields are to be included like an "or" statement What I'm trying to say is if all three calculated fields are true in one then it equals 3 and the other will equal 0 to be added...

I have a Main Survey form which a user can add a new record then enter data and then click to the next form to fill out the next form data for the same record (which contains subforms); they are linked by the same record # field called (AS Record#) but say i'm at record # 24 on the main survey...

Hello, I've done a search on refreshing forms but am not sure if/how I can relate any of the solutions to my problem. Summary: I have a main form called Accessibilty Survey Form which then through a button links to a second form called External form which has built in subforms. The Main form...