continuous form problem

[Jean-Paul De Winter]

Hi

I crearted a continuous form
Depending of what the value of a field is, I want to show or hide other
object
The first record is OK, others don't follow the "rules"
In the current event I wrote:


If Me!vak = "XYZ" Then
Me!BGV_Methode.Visible = False
Else
Me!BGV_Methode.Visible = True
End If


Who can help?
Thanks
JP

 

[Allen Browne]

Yes, that approach will not do what you want. The field will be shown or
hidden for ALL records in the subform, based on the value in the current
record.

You cannot actually hide controls conditionally, but you can simulate it
with Conditional Formatting. Stephen Lebans has an example at www.lebans.com

 

[Jean-Paul De WInter]

In conditional formattin I wrote something like:

Expression is
iff(Me!Plaats="K",Me!Max_prijs.visible=true,,Me!Max_prijs.visible=False)

Which doesn't work

Any help would be nice
Thanks
JP

 

[Allen Browne]

Perhaps you could read the 2nd paragraph of my previous reply.

 

[Jean-Paul De WInter]

which I did Allen... but this is very complicated for a beginner...
Sorry
JP