continuous form conundrum

[OhioSteve]

Here is my situation:
1. I have a form with the default view "Continuous Forms". So it displays many rows of data.
2. The form has the textboxes text1 and text2. Text2 is usually invisible.
3. If the user changes text1 to the value "x", I make text2 visible. I do this in text1's after update event.

Here is my problem:
If the user changes text1 to "x", then the text2 field on EVERY row becomes visible. I just want the text2 field for the active row to become visible.

Please advise.

 

[PHV]

Have a look at conditional formatting.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[straybullet]

In addition to the conditional formatting, keep in mind that unbound textboxes on continuous forms will behave as described.

Let them hate - so long as they fear... Lucius Accius

 

[OhioSteve]

PHV,

conditional formatting involves one item alone. For example, you could make a text box visible of the value bound to it equalled three. My scenario involves two items. If text1 is "x", then text2 is visible.

strayBullet,

They are both bound if that makes a difference.

everyone,

There must a way to say "this particular row" in vba.

 

[PHV]

The expression is: [Text1]='x'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[OhioSteve]

Oh! I think I've almost got it. I need to identify the active row.