Beffudled....Please Help With Tab Caption

Background:

I am trying to write a Macro which will change the Caption of Several Tab Control Pages, based on entries in a Table.

Here is the entire three step macro:

Open Form
Form Name: Draft
View: Design
Filter Name: <none>
Where Condition: <none>
Data Mode: Edit
Window Mode: Normal
SetValue
Item: [Forms]![Draft]![TabCtl32].[Pages](1).[Caption]
Expression: =DLookUp("[BFL Team]","BFL Teams","[ID] = 8")
Close
Object Type: Form
Object Name: Draft
Save: Yes

All Appears OK, except I get two different results, depending on what I try to name the Tab Caption.

If the Value in the "BFL Teams" Table pointed to by the DLookUp Statement is a number (Like 1234), all is well, the Macro Executes as expected, and the Tab Caption is updated to 1234.

What is madening is that I want to use an alphanumeric name. When I try to use anything other than Numbers, (Lets use 'Text' as an example) the Macro Barfs on the second statement with the message:

"Microsoft Access can't find the name "Text" you entered in the expression"



I am using Access 97, if that helps. The entire Database is automated using only Macros (No Modules).

This is my Fantasy Football League Draft Software that I have developed over the past several years. I am by no means an Access Ace, I just got this thing to work through trial and (lots of) error, for the most part.

What I am trying to do is to automate the changes I have to make every year, and one of them is to handle changes of Team Names, and I have a Tab Control for each Team with the Team Name as the Caption.

I would just like to have the Captions on each Team Page to be updated from entries in the "BFL Teams" Table, as part of a Macro I would run to automatically set up the Tables, Forms and Reports each year, rather than make the Brute Force Changes on an anual basis.

I am sure that I am just doing something bone headed, but for the life of me, I am at a loss on how to proceed.

Thank you to anyone who takes the time to look into this.