Continuing on variable form caption from before...

[christheancient]

Mike-O-Phile gave me a lovely solution to my desire to have a form caption in the title bar that reflected the name of a customer and it worked beautifully.

I even managed to use =IIf() to blank out a null and felt pretty pleased with myself (shows the level of my ability )

However... (The dreaded word) Is there any way I can make it update if I change the form to the next record? I've tried "rewriting" the caption statement on various On*** events - but with no success.

Any thoughts folks?

TIA

Chris

 

[Fornatian]

Are you sure you have tried your code(or a call to it) in the OnCurrent event?

 

[christheancient]

Fornation...

You've come up trumps! Many thanks.

(I think On Current was aboout the only one I didn't try - but then I was groping in the dark a bit and using the "let's see if this works then" attitude.)

My problems are solved.

Sorry about slight delay in writing - I had to go and do a little work and earn a little money.

Chris