Form field not returning same info as query info it's based on

[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!

 

[Rodrigo]

You need to change the Bound property on you combo box to the column with
the initials/client name/etc. It's probably in 1 right know and 1 is the
first column on the query which is usually the primary key.


Rodrigo.

 

[denilynn]

This still doesn't work. Do I base these combo boxes on
the column locations in the query, or on the columns in
the tables the query pulls them from?

 

[Rodrigo]

The query. They are 1 based (from left to right).

This still doesn't work. Do I base these combo boxes on
the column locations in the query, or on the columns in
the tables the query pulls them from?