Text Box default value

[Guest]

Hello.
I have a form and on this form I have a text box called "FE Owner".
This text box does not have a control source to any table.

What I need is the default value of this text box to point to a table called
"tbl_FEOwner" and to a field called "DB Front End Owner"
I only have one person in the table field. I have tried using:
=[tbl_FEOwner]![DB Front End Owner]
but id doesn't work.
I even added a second field to the table called "Default" with a Yes/No
field and tried linking the text box somehow to the "DB Front End Owner"
field with a check, but cant'.
What am I doing wrong?

Iram/mcp

 

[Douglas J. Steele]

You cannot retrieve data like that.

Try:

=DLookup("[DB Front End Owner]", "[tbl_FEOwner]")

Another option to keeping it in a table, by the way, would be to create a
database property and set it. Check the CreateProperty method in the Help
file for an example.

 

[Guest]

Perfect! The =Dlookup code worked perfectly!

Thanks.

You cannot retrieve data like that.

Try:

=DLookup("[DB Front End Owner]", "[tbl_FEOwner]")

Another option to keeping it in a table, by the way, would be to create a
database property and set it. Check the CreateProperty method in the Help
file for an example.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hello.
I have a form and on this form I have a text box called "FE Owner".
This text box does not have a control source to any table.

What I need is the default value of this text box to point to a table
called
"tbl_FEOwner" and to a field called "DB Front End Owner"
I only have one person in the table field. I have tried using:
=[tbl_FEOwner]![DB Front End Owner]
but id doesn't work.
I even added a second field to the table called "Default" with a Yes/No
field and tried linking the text box somehow to the "DB Front End Owner"
field with a check, but cant'.
What am I doing wrong?

Iram/mcp

 

[Douglas J. Steele]

Yes, it will work perfectly...until you put another row in the table.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Perfect! The =Dlookup code worked perfectly!

Thanks.

You cannot retrieve data like that.

Try:

=DLookup("[DB Front End Owner]", "[tbl_FEOwner]")

Another option to keeping it in a table, by the way, would be to create a
database property and set it. Check the CreateProperty method in the Help
file for an example.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hello.
I have a form and on this form I have a text box called "FE Owner".
This text box does not have a control source to any table.

What I need is the default value of this text box to point to a table
called
"tbl_FEOwner" and to a field called "DB Front End Owner"
I only have one person in the table field. I have tried using:
=[tbl_FEOwner]![DB Front End Owner]
but id doesn't work.
I even added a second field to the table called "Default" with a Yes/No
field and tried linking the text box somehow to the "DB Front End
Owner"
field with a check, but cant'.
What am I doing wrong?

Iram/mcp

 

[Guest]

I totally understand. Thanks.
IRam

Yes, it will work perfectly...until you put another row in the table.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Perfect! The =Dlookup code worked perfectly!

Thanks.

You cannot retrieve data like that.

Try:

=DLookup("[DB Front End Owner]", "[tbl_FEOwner]")

Another option to keeping it in a table, by the way, would be to create a
database property and set it. Check the CreateProperty method in the Help
file for an example.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Hello.
I have a form and on this form I have a text box called "FE Owner".
This text box does not have a control source to any table.

What I need is the default value of this text box to point to a table
called
"tbl_FEOwner" and to a field called "DB Front End Owner"
I only have one person in the table field. I have tried using:
=[tbl_FEOwner]![DB Front End Owner]
but id doesn't work.
I even added a second field to the table called "Default" with a Yes/No
field and tried linking the text box somehow to the "DB Front End
Owner"
field with a check, but cant'.
What am I doing wrong?

Iram/mcp