Continuous Form View

[VeeFour]

Is it possible to change the contents of continuous form using a field value on a particular record without it altering the whole list of forms?

I currently show records in continuous forms like this:

Name Policy(LTA) Sum Term
-----------------------------------------
Name Policy(LTA) Sum Term
-----------------------------------------
Name Policy(LTA) Sum Term
-----------------------------------------

I want to show the continuous forms like this when the Policy field has a different value:

Name Policy(LTA) Sum Term
-----------------------------------------
Name Policy(PHI) ToAge RPI
-----------------------------------------
Name Policy(LTA) Sum Term
-----------------------------------------

I am currently using a conditional expression:
If Me![Policy]="PHI" Then Me![Sum].Visible=No
If Me![Policy]="PHI" Then Me![ToAge].Visible=Yes
If Me![Policy]="PHI" Then Me![RPI].Visible=Yes

This seems to apply the function to all records in the continous forms and not just the forms where Policy ="PHI" :


Name Policy(LTA) ToAge RPI
-----------------------------------------
Name Policy(PHI) ToAge RPI
-----------------------------------------
Name Policy(LTA) ToAge RPI
-----------------------------------------

How do I apply changes to the forms containing the PHI value without changing all the records in the continuous form?

 

[PaulF]

change the ControlSource for the TextBoxes to IIf statements

= IIf([Policy]="PHI",[ToAge],[Sum])
= IIf([Policy]="PHI",[RPI],[Term])

PaulF

 

[VeeFour]

Tried that method but it does not allow me to edit the text box because it is bound to the expression and I also need to Show / Hide labels and Fields dependant on each record.

 

[PaulF]

sorry I don't know of a way to do it in a continuous form without using an IIf statement.

PaulF