Change Document tab* name in VBA

[ECEK]

As it says on the tin really ?

The database is a Tabbed Documents with Display Document Tabs ticked style database.

At present I have my opening list of clients on the summary form then (on double-click ) open a Client form (Called "Client") with the specific data in it.

Just wondered if anybody knows if its possible to rename the form and therefore the tab at the top, to the name of the client? (That I had selected)

Thanks for your time.

*This is not about tab names within a form.

 

[isladogs]

Yes - its easy

In the form load event add something like

Me.Caption = "Client - " & [Client]

That works for both tabbed documents and overlapping windows

 

[ECEK]

Brilliant Ridders !!
works a treat.

Many thanks

 

[isladogs]

You're welcome