Text box in field doesn't return same info as in query field it's based on

  • Thread starter Thread starter denilynn
  • Start date Start date
D

denilynn

I have a combobox field in a form that's based on a field
in a query, which obviously is pulled from a table. I then
have associated (textbox) fields in the form automatically
fill in based on the choice made in the combobox field. My
problem is that the query returns a client name (for
instance), but the textbox field in the form is returning
the client ID. Same case with Analyst ID being returned
as opposed to Analyst's Initials in the form. Thanks in
advance for your help!
 
A likely scenario is as follows
1. The RowSource query is selecting clientName and clientId
2. The BoundColumn is set to 2.
3. The automatic population of the text field is something
like {textbox} = {combobox}

If this is correct, then waht you need to do is to change
the automatic population to something like {textbox}.Value
= {combobox}.Column(1)

If this is not correct, can you provide details of the above.

Hope That Helps
Gerald Stanley MCSD
 
The RowSource Query is selecting clientName and clientID
and I think this was created when I used the lookupwizard
for the client ID field in my table that the query is
based on.

The Bound Column is set to 2.

The auto population of the text field is =[name of
combobox].column(1).

Any additional help is greatly appreciated!

Thanks!
 
Try changing the auto population of the text field to
=[name of combobox].column(0).

Hope That Helps
Gerald Stanley MCSD
-----Original Message-----
The RowSource Query is selecting clientName and clientID
and I think this was created when I used the lookupwizard
for the client ID field in my table that the query is
based on.

The Bound Column is set to 2.

The auto population of the text field is =[name of
combobox].column(1).

Any additional help is greatly appreciated!

Thanks!
-----Original Message-----
A likely scenario is as follows
1. The RowSource query is selecting clientName and clientId
2. The BoundColumn is set to 2.
3. The automatic population of the text field is something
like {textbox} = {combobox}

If this is correct, then waht you need to do is to change
the automatic population to something like {textbox}.Value
= {combobox}.Column(1)

If this is not correct, can you provide details of the above.

Hope That Helps
Gerald Stanley MCSD
.
Click to expand...
.
Click to expand...
 
When I do that it returns the value of the combobox
field.

Here's more info:

Table has the Client ID field, which is a combobox with
Row Source of SELECT [tblClients].[Client_ID],
[tblClients].[Client_Name] FROM tblClients. Used the
combobox wizard and that's where this Row Source was
created.

Query has Lab Code (primary key) as 1st column and Client
ID as 2nd field although the datasheet view shows
Client_Name.

Form has Lab Code as combobox (titled Lab Code)with above
query named as row source. Client Name text box has
control source of =[Lab Code].Column(1).

Thanks again in advance for any insight you may be able to
give me!
-----Original Message-----
Try changing the auto population of the text field to
=[name of combobox].column(0).

Hope That Helps
Gerald Stanley MCSD
-----Original Message-----
The RowSource Query is selecting clientName and clientID
and I think this was created when I used the lookupwizard
for the client ID field in my table that the query is
based on.

The Bound Column is set to 2.

The auto population of the text field is =[name of
combobox].column(1).

Any additional help is greatly appreciated!

Thanks!
-----Original Message-----
A likely scenario is as follows
1. The RowSource query is selecting clientName and clientId
2. The BoundColumn is set to 2.
3. The automatic population of the text field is something
like {textbox} = {combobox}

If this is correct, then waht you need to do is to change
the automatic population to something like {textbox}.Value
= {combobox}.Column(1)

If this is not correct, can you provide details of the above.

Hope That Helps
Gerald Stanley MCSD
-----Original Message-----
I have a combobox field in a form that's based on a field
in a query, which obviously is pulled from a table. I then
have associated (textbox) fields in the form automatically
fill in based on the choice made in the combobox
Click to expand...
field.
My
problem is that the query returns a client name (for
instance), but the textbox field in the form is returning
the client ID. Same case with Analyst ID being returned
as opposed to Analyst's Initials in the form. Thanks in
advance for your help!
.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
It seems odd to me that the Client Name text box is taking
its value from the Lab Code combo box instead of the Client
Id combo box. Are you sure that this is what you want. If
not, try changing its control source to [ClientId].Column(1)

Otherwise, what is the SQL of the query that is returning
the Client Id instead of the Client Name. Also, can you
provide some information on the table that has the Lab Code
as its primary key. In particular, how is it related to
tblClients.

Many thanks
Gerald Stanley MCSD
-----Original Message-----
When I do that it returns the value of the combobox
field.

Here's more info:

Table has the Client ID field, which is a combobox with
Row Source of SELECT [tblClients].[Client_ID],
[tblClients].[Client_Name] FROM tblClients. Used the
combobox wizard and that's where this Row Source was
created.

Query has Lab Code (primary key) as 1st column and Client
ID as 2nd field although the datasheet view shows
Client_Name.

Form has Lab Code as combobox (titled Lab Code)with above
query named as row source. Client Name text box has
control source of =[Lab Code].Column(1).

Thanks again in advance for any insight you may be able to
give me!
-----Original Message-----
Try changing the auto population of the text field to
=[name of combobox].column(0).

Hope That Helps
Gerald Stanley MCSD
-----Original Message-----
The RowSource Query is selecting clientName and clientID
and I think this was created when I used the lookupwizard
for the client ID field in my table that the query is
based on.

The Bound Column is set to 2.

The auto population of the text field is =[name of
combobox].column(1).

Any additional help is greatly appreciated!

Thanks!
-----Original Message-----
A likely scenario is as follows
1. The RowSource query is selecting clientName and
clientId
2. The BoundColumn is set to 2.
3. The automatic population of the text field is something
like {textbox} = {combobox}

If this is correct, then waht you need to do is to change
the automatic population to something like {textbox}.Value
= {combobox}.Column(1)

If this is not correct, can you provide details of the
above.

Hope That Helps
Gerald Stanley MCSD
-----Original Message-----
I have a combobox field in a form that's based on a
field
in a query, which obviously is pulled from a table. I
then
have associated (textbox) fields in the form
automatically
fill in based on the choice made in the combobox field.
My
problem is that the query returns a client name (for
instance), but the textbox field in the form is
returning
the client ID. Same case with Analyst ID being returned
as opposed to Analyst's Initials in the form. Thanks in
advance for your help!
.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
I'm pulling the info for my form from a query that
includes the fields I need to fill. My thought was by
using a query, the table won't update each time a
selection is made. Am I way off base?

The original table that includes the lab code as the
primary key is related to the Clients table by the Client
ID fields.

Could part of the problem may be that when I used the
combobox wizard, I used Client Name as the field values
that I want to display, so the row source reads SELECT
[tblClients].[Client_ID], [tblClients].[Client_Name] FROM
tblClients;

Thanks for your time!
-----Original Message-----
It seems odd to me that the Client Name text box is taking
its value from the Lab Code combo box instead of the Client
Id combo box. Are you sure that this is what you want. If
not, try changing its control source to [ClientId].Column (1)

Otherwise, what is the SQL of the query that is returning
the Client Id instead of the Client Name. Also, can you
provide some information on the table that has the Lab Code
as its primary key. In particular, how is it related to
tblClients.

Many thanks
Gerald Stanley MCSD
-----Original Message-----
When I do that it returns the value of the combobox
field.

Here's more info:

Table has the Client ID field, which is a combobox with
Row Source of SELECT [tblClients].[Client_ID],
[tblClients].[Client_Name] FROM tblClients. Used the
combobox wizard and that's where this Row Source was
created.

Query has Lab Code (primary key) as 1st column and Client
ID as 2nd field although the datasheet view shows
Client_Name.

Form has Lab Code as combobox (titled Lab Code)with above
query named as row source. Client Name text box has
control source of =[Lab Code].Column(1).

Thanks again in advance for any insight you may be able to
give me!
-----Original Message-----
Try changing the auto population of the text field to
=[name of combobox].column(0).

Hope That Helps
Gerald Stanley MCSD
-----Original Message-----
The RowSource Query is selecting clientName and clientID
and I think this was created when I used the lookupwizard
for the client ID field in my table that the query is
based on.

The Bound Column is set to 2.

The auto population of the text field is =[name of
combobox].column(1).

Any additional help is greatly appreciated!

Thanks!
-----Original Message-----
A likely scenario is as follows
1. The RowSource query is selecting clientName and
clientId
2. The BoundColumn is set to 2.
3. The automatic population of the text field is something
like {textbox} = {combobox}

If this is correct, then waht you need to do is to change
the automatic population to something like {textbox}.Value
= {combobox}.Column(1)

If this is not correct, can you provide details of the
above.

Hope That Helps
Gerald Stanley MCSD
-----Original Message-----
I have a combobox field in a form that's based on a
field
in a query, which obviously is pulled from a table. I
then
have associated (textbox) fields in the form
automatically
fill in based on the choice made in the combobox field.
My
problem is that the query returns a client name (for
instance), but the textbox field in the form is
returning
the client ID. Same case with Analyst ID being returned
as opposed to Analyst's Initials in the form. Thanks in
advance for your help!
.

.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Thanks for that. Befors I make any more suggestions, let's
summarise where we are at.

You have a combo box for selecting the Client. Its
dropdown shows the ClientId and the ClientName and its text
box shows the ClientName for the selected item.

You have another combo box for selecting the lab. Its
dropdown shows the LabId and the ClientId and its text box
shows the LabId for the selected item.

You have a text box that you want to show the ClientName
for the ClientId associated to the selected LabId. But the
text box is showing the ClientId.

Is that correct?

Gerald
-----Original Message-----
I'm pulling the info for my form from a query that
includes the fields I need to fill. My thought was by
using a query, the table won't update each time a
selection is made. Am I way off base?

The original table that includes the lab code as the
primary key is related to the Clients table by the Client
ID fields.

Could part of the problem may be that when I used the
combobox wizard, I used Client Name as the field values
that I want to display, so the row source reads SELECT
[tblClients].[Client_ID], [tblClients].[Client_Name] FROM
tblClients;

Thanks for your time!
-----Original Message-----
It seems odd to me that the Client Name text box is taking
its value from the Lab Code combo box instead of the Client
Id combo box. Are you sure that this is what you want. If
not, try changing its control source to [ClientId].Column (1)

Otherwise, what is the SQL of the query that is returning
the Client Id instead of the Client Name. Also, can you
provide some information on the table that has the Lab Code
as its primary key. In particular, how is it related to
tblClients.

Many thanks
Gerald Stanley MCSD
-----Original Message-----
When I do that it returns the value of the combobox
field.

Here's more info:

Table has the Client ID field, which is a combobox with
Row Source of SELECT [tblClients].[Client_ID],
[tblClients].[Client_Name] FROM tblClients. Used the
combobox wizard and that's where this Row Source was
created.

Query has Lab Code (primary key) as 1st column and Client
ID as 2nd field although the datasheet view shows
Client_Name.

Form has Lab Code as combobox (titled Lab Code)with above
query named as row source. Client Name text box has
control source of =[Lab Code].Column(1).

Thanks again in advance for any insight you may be able to
give me!
-----Original Message-----
Try changing the auto population of the text field to
=[name of combobox].column(0).

Hope That Helps
Gerald Stanley MCSD
-----Original Message-----
The RowSource Query is selecting clientName and clientID
and I think this was created when I used the
lookupwizard
for the client ID field in my table that the query is
based on.

The Bound Column is set to 2.

The auto population of the text field is =[name of
combobox].column(1).

Any additional help is greatly appreciated!

Thanks!
-----Original Message-----
A likely scenario is as follows
1. The RowSource query is selecting clientName and
clientId
2. The BoundColumn is set to 2.
3. The automatic population of the text field is
something
like {textbox} = {combobox}

If this is correct, then waht you need to do is to
change
the automatic population to something like
{textbox}.Value
= {combobox}.Column(1)

If this is not correct, can you provide details of the
above.

Hope That Helps
Gerald Stanley MCSD
-----Original Message-----
I have a combobox field in a form that's based on a
field
in a query, which obviously is pulled from a table. I
then
have associated (textbox) fields in the form
automatically
fill in based on the choice made in the combobox
field.
My
problem is that the query returns a client name (for
instance), but the textbox field in the form is
returning
the client ID. Same case with Analyst ID being
returned
as opposed to Analyst's Initials in the form. Thanks
in
advance for your help!
.

.

.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Sorry - it's been awhile! My database was corrupt so did
some re-creating. Anyway, yes, what you've stated sounds
correct. Thanks for your advice.
-----Original Message-----
Thanks for that. Befors I make any more suggestions, let's
summarise where we are at.

You have a combo box for selecting the Client. Its
dropdown shows the ClientId and the ClientName and its text
box shows the ClientName for the selected item.

You have another combo box for selecting the lab. Its
dropdown shows the LabId and the ClientId and its text box
shows the LabId for the selected item.

You have a text box that you want to show the ClientName
for the ClientId associated to the selected LabId. But the
text box is showing the ClientId.

Is that correct?

Gerald
-----Original Message-----
I'm pulling the info for my form from a query that
includes the fields I need to fill. My thought was by
using a query, the table won't update each time a
selection is made. Am I way off base?

The original table that includes the lab code as the
primary key is related to the Clients table by the Client
ID fields.

Could part of the problem may be that when I used the
combobox wizard, I used Client Name as the field values
that I want to display, so the row source reads SELECT
[tblClients].[Client_ID], [tblClients].[Client_Name] FROM
tblClients;

Thanks for your time!
-----Original Message-----
It seems odd to me that the Client Name text box is taking
its value from the Lab Code combo box instead of the Client
Id combo box. Are you sure that this is what you
Click to expand...
want.
If
not, try changing its control source to
Click to expand...
[ClientId].Column
(1)
Otherwise, what is the SQL of the query that is returning
the Client Id instead of the Client Name. Also, can you
provide some information on the table that has the Lab Code
as its primary key. In particular, how is it related to
tblClients.

Many thanks
Gerald Stanley MCSD
-----Original Message-----
When I do that it returns the value of the combobox
field.

Here's more info:

Table has the Client ID field, which is a combobox with
Row Source of SELECT [tblClients].[Client_ID],
[tblClients].[Client_Name] FROM tblClients. Used the
combobox wizard and that's where this Row Source was
created.

Query has Lab Code (primary key) as 1st column and Client
ID as 2nd field although the datasheet view shows
Client_Name.

Form has Lab Code as combobox (titled Lab Code)with above
query named as row source. Client Name text box has
control source of =[Lab Code].Column(1).

Thanks again in advance for any insight you may be
Click to expand...
able
to
give me!
-----Original Message-----
Try changing the auto population of the text field to
=[name of combobox].column(0).

Hope That Helps
Gerald Stanley MCSD
-----Original Message-----
The RowSource Query is selecting clientName and clientID
and I think this was created when I used the
lookupwizard
for the client ID field in my table that the query is
based on.

The Bound Column is set to 2.

The auto population of the text field is =[name of
combobox].column(1).

Any additional help is greatly appreciated!

Thanks!
-----Original Message-----
A likely scenario is as follows
1. The RowSource query is selecting clientName and
clientId
2. The BoundColumn is set to 2.
3. The automatic population of the text field is
something
like {textbox} = {combobox}

If this is correct, then waht you need to do is to
change
the automatic population to something like
{textbox}.Value
= {combobox}.Column(1)

If this is not correct, can you provide details of the
above.

Hope That Helps
Gerald Stanley MCSD
-----Original Message-----
I have a combobox field in a form that's based on a
field
in a query, which obviously is pulled from a
Click to expand...
table.
I
then
have associated (textbox) fields in the form
automatically
fill in based on the choice made in the combobox
field.
My
problem is that the query returns a client name (for
instance), but the textbox field in the form is
returning
the client ID. Same case with Analyst ID being
returned
as opposed to Analyst's Initials in the form. Thanks
in
advance for your help!
.

.

.

.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Where do I go from here? Thanks!
-----Original Message-----
Sorry - it's been awhile! My database was corrupt so did
some re-creating. Anyway, yes, what you've stated sounds
correct. Thanks for your advice.
-----Original Message-----
Thanks for that. Befors I make any more suggestions, let's
summarise where we are at.

You have a combo box for selecting the Client. Its
dropdown shows the ClientId and the ClientName and its text
box shows the ClientName for the selected item.

You have another combo box for selecting the lab. Its
dropdown shows the LabId and the ClientId and its text box
shows the LabId for the selected item.

You have a text box that you want to show the ClientName
for the ClientId associated to the selected LabId. But the
text box is showing the ClientId.

Is that correct?

Gerald
-----Original Message-----
I'm pulling the info for my form from a query that
includes the fields I need to fill. My thought was by
using a query, the table won't update each time a
selection is made. Am I way off base?

The original table that includes the lab code as the
primary key is related to the Clients table by the Client
ID fields.

Could part of the problem may be that when I used the
combobox wizard, I used Client Name as the field values
that I want to display, so the row source reads SELECT
[tblClients].[Client_ID], [tblClients].[Client_Name] FROM
tblClients;

Thanks for your time!
-----Original Message-----
It seems odd to me that the Client Name text box is taking
its value from the Lab Code combo box instead of the
Client
Id combo box. Are you sure that this is what you want.
If
not, try changing its control source to [ClientId].Column
(1)

Otherwise, what is the SQL of the query that is returning
the Client Id instead of the Client Name. Also, can you
provide some information on the table that has the Lab
Code
as its primary key. In particular, how is it related to
tblClients.

Many thanks
Gerald Stanley MCSD
-----Original Message-----
When I do that it returns the value of the combobox
field.

Here's more info:

Table has the Client ID field, which is a combobox with
Row Source of SELECT [tblClients].[Client_ID],
[tblClients].[Client_Name] FROM tblClients. Used the
combobox wizard and that's where this Row Source was
created.

Query has Lab Code (primary key) as 1st column and
Client
ID as 2nd field although the datasheet view shows
Client_Name.

Form has Lab Code as combobox (titled Lab Code)with
above
query named as row source. Client Name text box has
control source of =[Lab Code].Column(1).

Thanks again in advance for any insight you may be able
to
give me!
-----Original Message-----
Try changing the auto population of the text field to
=[name of combobox].column(0).

Hope That Helps
Gerald Stanley MCSD
-----Original Message-----
The RowSource Query is selecting clientName and
clientID
and I think this was created when I used the
lookupwizard
for the client ID field in my table that the query is
based on.

The Bound Column is set to 2.

The auto population of the text field is =[name of
combobox].column(1).

Any additional help is greatly appreciated!

Thanks!
-----Original Message-----
A likely scenario is as follows
1. The RowSource query is selecting clientName and
clientId
2. The BoundColumn is set to 2.
3. The automatic population of the text field is
something
like {textbox} = {combobox}

If this is correct, then waht you need to do is to
change
the automatic population to something like
{textbox}.Value
= {combobox}.Column(1)

If this is not correct, can you provide details of
the
above.

Hope That Helps
Gerald Stanley MCSD
-----Original Message-----
I have a combobox field in a form that's based on a
field
in a query, which obviously is pulled from a table.
I
then
have associated (textbox) fields in the form
automatically
fill in based on the choice made in the combobox
field.
My
problem is that the query returns a client name (for
instance), but the textbox field in the form is
returning
the client ID. Same case with Analyst ID being
returned
as opposed to Analyst's Initials in the form. Thanks
in
advance for your help!
.

.

.

.

.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top