No data from combo box

Experts,
In my form I have a combo box where the row source is based upon this query:
SELECT DISTINCT tblStore.StoreNumberID, 
tblStore.StoreNumber, "# " & [StoreNumber] & " "
 & [StoreAddressOne] AS Store,
 (Select tblEmployee.EmployeeFirstName
  FROM tblEmployee
 INNER JOIN tblDesignatedEmployee  
ON tblEmployee.EmployeeID = tblDesignatedEmployee.EmployeeID Where tblDesignatedEmployee.StoreID = tblStore.StoreNumberID
 And tblDesignatedEmployee.EmployeeTypeID=1) AS
 DistrictManager, (Select tblEmployee.EmployeeFirstName 
 FROM tblEmployee
 INNER JOIN tblDesignatedEmployee 
 ON tblEmployee.EmployeeID = tblDesignatedEmployee.EmployeeID
 Where tblDesignatedEmployee.StoreID = tblStore.StoreNumberID And tblDesignatedEmployee.EmployeeTypeID=2) 
AS StoreManager, (Select tblEmployee.EmployeeFirstName
  FROM tblEmployee INNER JOIN tblDesignatedEmployee ON 
 tblEmployee.EmployeeID = tblDesignatedEmployee.EmployeeID Where tblDesignatedEmployee.StoreID = tblStore.StoreNumberID 
And tblDesignatedEmployee.EmployeeTypeID=3)
 AS AssistantManager, (Select tblEmployee.EmployeeFirstName
  FROM tblEmployee 
INNER JOIN tblDesignatedEmployee
  ON tblEmployee.EmployeeID = tblDesignatedEmployee.EmployeeID
 Where tblDesignatedEmployee.StoreID = tblStore.StoreNumberID
 And tblDesignatedEmployee.EmployeeTypeID=5) AS AreaSupportManager
FROM tblStore;

Open in new window

In my form I have 4 text boxes that receive data from the above query as follows:
=[StoreID].[column](3)
=[StoreID].[column](6)
=[StoreID].[column](4)
=[StoreID].[column](5)
I get the data I'm looking for in the first text box but nothing in the other three?
Frank FreeseAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
did you set column count property of the combo box to at least 7
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mbizupCommented:
Shouldn't it be like this according to your four column select statement?


=[StoreID].[column](0)
=[StoreID].[column](1)
=[StoreID].[column](2)
=[StoreID].[column](3)

0
mbizupCommented:
You only have four columns selected, but you are referring to columns higher than that.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Rey Obrero (Capricorn1)Commented:
the query you have above will show 7 columns

StoreNumberID      StoreNumber      Store      DistrictManager      StoreManager      AssistantManager      AreaSupportManager

so you need to set the Column Count property of the combo box to 7

0
Rey Obrero (Capricorn1)Commented:
see this, look at form "frmBonusEarned" combo storeid
StoreBonusRev.mdb
0
Frank FreeseAuthor Commented:
you nailed it capricorn - I forgot to change the number of columns. Everything is ok. thank you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.