ComboBox Data in a text Box

[pointies]

I have a form with a ComboBox with a list of users. The ComboBox is
set on a Table/Query to look up the Employee Names by their ID. The
ComboBox is named AssignedTo

If I set up a Textbox with =AssignedTo , it will just display the ID of
the Employee. How do I go about so that this box will show the name
instead?

Thanks in advance

[Bob Quintal]

po******@gmail.com wrote in
news:11**********************@i42g2000cwa.googlegr oups.com:

I have a form with a ComboBox with a list of users. The
ComboBox is set on a Table/Query to look up the Employee Names
by their ID. The ComboBox is named AssignedTo

If I set up a Textbox with =AssignedTo , it will just display
the ID of the Employee. How do I go about so that this box
will show the name instead?

Thanks in advance

From your description, the combobox has two columns in the dropdown
portion. If you want to access the information in a supplemental
column, you would refer to it as AssignedTo.column(n) with n being
the sequence from left to right, starting with 0 for the first
column.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[pointies]

Hey Bob,

That works perfectly. Now I have another problem.

I can get it work for one of the fields but not the other...

For Example, In a text field, =AssignedTo will show me a number (1 for
example), =AssignedTo.Column(1) will show me the name

But If I put inthe TextField, =Provider will show me a number (1 for
example), but when I put in =AssignedTo.Column(1), it shows #name?

I know it is something super simple... but I can't figure it out..
Bob Quintal wrote:

po******@gmail.com wrote in
news:11**********************@i42g2000cwa.googlegr oups.com:

I have a form with a ComboBox with a list of users. The
ComboBox is set on a Table/Query to look up the Employee Names
by their ID. The ComboBox is named AssignedTo

If I set up a Textbox with =AssignedTo , it will just display
the ID of the Employee. How do I go about so that this box
will show the name instead?

Thanks in advance

From your description, the combobox has two columns in the dropdown
portion. If you want to access the information in a supplemental
column, you would refer to it as AssignedTo.column(n) with n being
the sequence from left to right, starting with 0 for the first
column.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[pointies]

Just a little more detail on these fields:

They are both set to number date type (Long Integer) and Yes Duplicates
OK in Indexed, in a main table that reference their own table, Provider
and Contacts.

In the Main Table, both have this attribute:
Display Control: Combo Box
Row Source Type: Table/Query
Bound Column: 1
Column Count: 2
Column Heads: No
Column Widths: 0";1"
List Rows: 15
List Width: Auto
Limit to List: Yes

The ONLY difference is the Row Source:

The Provider is set up as:
SELECT Providers.ID, Providers.FirstName & " " & Providers.LastName & "
, " & Providers.Title AS Expr1 FROM Providers ORDER BY
Providers.LastName;

AssignedTo is set up as:
SELECT Contacts.ID, Contacts.FirstName & " " & Contacts.LastName AS
Expr1 FROM Contacts ORDER BY Contacts.LastName;

Their respective tables are set up near identical to each other, just
vital information and contact number and such..

Please help..



[e-mail] wrote:

Hey Bob,

That works perfectly. Now I have another problem.

I can get it work for one of the fields but not the other...

For Example, In a text field, =AssignedTo will show me a number (1 for
example), =AssignedTo.Column(1) will show me the name

But If I put inthe TextField, =Provider will show me a number (1 for
example), but when I put in =AssignedTo.Column(1), it shows #name?

I know it is something super simple... but I can't figure it out..
Bob Quintal wrote:

po******@gmail.com wrote in
news:11**********************@i42g2000cwa.googlegr oups.com:

I have a form with a ComboBox with a list of users. The
ComboBox is set on a Table/Query to look up the Employee Names
by their ID. The ComboBox is named AssignedTo
>
If I set up a Textbox with =AssignedTo , it will just display
the ID of the Employee. How do I go about so that this box
will show the name instead?
>
Thanks in advance
>

From your description, the combobox has two columns in the dropdown
portion. If you want to access the information in a supplemental
column, you would refer to it as AssignedTo.column(n) with n being
the sequence from left to right, starting with 0 for the first
column.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Bob Quintal]

The #name error indicator is usually caused by one or the other
of the following problems, 1) a typographical error in the name
of the referenced control, 2) a circular reference between a
text/combo/listbox contrrol and the name of a field in hte
recordsource of the form.

Bob
po******@gmail.com wrote in
news:11**********************@m79g2000cwm.googlegr oups.com:

Hey Bob,

That works perfectly. Now I have another problem.

I can get it work for one of the fields but not the other...

For Example, In a text field, =AssignedTo will show me a
number (1 for example), =AssignedTo.Column(1) will show me the
name

But If I put inthe TextField, =Provider will show me a number
(1 for example), but when I put in =AssignedTo.Column(1), it
shows #name?

I know it is something super simple... but I can't figure it
out..
Bob Quintal wrote:

>po******@gmail.com wrote in
news:11**********************@i42g2000cwa.googleg roups.com:

I have a form with a ComboBox with a list of users. The
ComboBox is set on a Table/Query to look up the Employee
Names by their ID. The ComboBox is named AssignedTo

If I set up a Textbox with =AssignedTo , it will just
display the ID of the Employee. How do I go about so that
this box will show the name instead?

Thanks in advance

From your description, the combobox has two columns in the
dropdown portion. If you want to access the information in a
supplemental column, you would refer to it as
AssignedTo.column(n) with n being the sequence from left to
right, starting with 0 for the first column.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com