Sintaxe in textbox

[Guest]

Hi!

In form I have a combo with three columns, where the second is IdNumber, but
hidden.
I Would like which the syntax in the Source Control of one textbox of form,
to show us the value of the related hidden IdNumber.

Thanks in advance.
an

 

[tina]

the syntax to display the value from a combo box column in an unbound
textbox control on the same form is

=[ComboBoxName].[Column](1)

replace ComboBoxName with the correct name of the combo box control, of
course. note that the combo box column index is zero-based, so the first
column (counting from left to right) is 0, the second column is 1, etc.

hth

 

[Arvin Meyer [MVP]]

Forms!FormName!ComboName.Column(1)

for the second column. The column index is zero based.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thanks for your reply.

That is a desperation...
Already before it had attemped both your solutions.
Result:
Empty TxtBox

Changed the textbox name, I erased and I made another one. Nothing!
Thanks.
an

the syntax to display the value from a combo box column in an unbound
textbox control on the same form is

=[ComboBoxName].[Column](1)

replace ComboBoxName with the correct name of the combo box control, of
course. note that the combo box column index is zero-based, so the first
column (counting from left to right) is 0, the second column is 1, etc.

hth

Hi!

In form I have a combo with three columns, where the second is IdNumber, but
hidden.
I Would like which the syntax in the Source Control of one textbox of form,
to show us the value of the related hidden IdNumber.

Thanks in advance.
an

 

[Guest]

AM,

Thanks for your reply.

Already before it had attemped your solution.
Result:
Empty TxtBox

Changed the textbox name, I erased and I made another one. Nothing!
Where it could be the problem, please?
an

 

[Guest]

Tina,

The problem was because the cbo passed to "" after to send the content for
another one textbox.

Thanks you.
an

the syntax to display the value from a combo box column in an unbound
textbox control on the same form is

=[ComboBoxName].[Column](1)

replace ComboBoxName with the correct name of the combo box control, of
course. note that the combo box column index is zero-based, so the first
column (counting from left to right) is 0, the second column is 1, etc.

hth

Hi!

In form I have a combo with three columns, where the second is IdNumber, but
hidden.
I Would like which the syntax in the Source Control of one textbox of form,
to show us the value of the related hidden IdNumber.

Thanks in advance.
an

 

[Guest]

AM,

The problem was because the cbo passed to "" after to send the content for
another one textbox.

Work fine after to put = before code.
Thanks you too.

an