Search results

FeeElection field is a number - percentage. Don't want to change it to a text field 'cause I need to make calculations against it elsewhere. R. Fisher

Mark - Getting closer (I think). All three subforms (0%Subform, 40%Subform & 50% Subform) are on the main form with "visible"=No for all three. On all 3 subforms, in the "On Current" I copied your "IF" statement as it appears - making the neceesary changes to reflect the actual field name and...

OK, my next adventure is this: On my main form, I have a field (FeePercent) which can contain one of three possibilities; 0%, 40% or 50%. I have three subforms defined, one for each of the 3 percentages from this field. When I open the main form, I would like to know if it is possible to have...

Many Thanks! Works Great - Thanks Much!

I have a form that is a display form for presenting statistical info. The table/field info are: Table = ClientTracking / field = InvoiceDate Table = CheckDetails / field = EstRefund I am trying to present on the stats form the year-to-date and month-to-date totals of the EstRefund field...