Form refresh is unbelievably show

[martingaleh]

I have a subform and I highlight the active record by making a textbox behind all the controls and setting it equal to a textbox on the parent form which itself is equal to the value of the subform. Then I use conditional formatting to format it so only the textbox behind the active record is highlighted
http://answers.microsoft.com/en-us/o...ebcab84?auth=1

In 2010, you have to also do form.refresh for the textbox color to change when the conditional formatting is fulfilled and this color change is dog slow. Like dial up modem speed slow. Google delivers results to my computer from a data center in Kansas City faster than access makes one text box blue. Can this really be true? I'm on a pretty fast computer, like an i7. I don't play games on it, but it delivers the late show with stephen colbert at a legitimate speed. Maybe I've got to refresh only the text box. I don't know, it's a big mystery. Is there a way to speed it up?

[June7]

I very much doubt it.

But why a form/subform? Unless the main form is bound and subform is linked to main form, this could be a single form in Continuous view with the search controls in form Header section.

[martingaleh]

It's just aesthetics. If I didn't have that large listbox on the side for child item manipulations, It could have all been on one form.

[June7]

Does listbox need to be that large? What is its purpose?

Even the listbox could be in form header.

[CJ_London]

rather than messing around with updating your main form etc. which is going round the houses and taking the time - try this

1. make your conditional textbox unbound
2. change the condition for the back color to be Field Value Is...equal to...[haskins]
3. in the subform current event put
conditionaltextbox=haskins

I'm assuming haskins is the unique id for the row and you'll need to use the correct name for your conditional textbox