Variable form caption

[christheancient]

Somewhere, in the past, I have seen a form that has a caption giving "variable" information - like a customer's name.

I am designing a simple (but complex to a "noddy" like me) database of customer records.

My database is more than adequate with defined captions for the basic user form, but I would like to be a smarty-pants and impress myself by having a form caption that may say something like "Customer record for [FirstName] & " " & [LastName]" but I've not managed to crack it.

Any thoughts, folks.

tia

Chris

 

[Mile-O]

In the forms OnLoad property you could put;

Me.Caption = "Customer Information for " & strCustomerName

 

[christheancient]

Mile-O-Phile...

Thanks. It works!

I am suitably impressed - let's hope my users are.

ps What took so long

Chris