Combo Box - Display value of current record

[ToniS]

I am currently using Access 2003 and SQL Server as my Backend.

I have a form with a detial section and the default view is continious form.
The detail section displays all of the records correctly except for my combo
box. The other information with in the detail section are text boxes...
If I click on the dropdown arrow I can view the store numbers. I would like
it to display the store number for that record instead of not displaying
anything.

Below is my Record Source for the form

SELECT DSR.DealerShowRebateID, DSR.DealerShowID, DSR.DealerRebateTypeID,
DSR.DealerRebateCheckNumber, DSR.RebateDescription, DSR.RebateAmount,
DS.ShowID, DS.MemberID, ML.Store#
FROM DealerShowRebates DSR
INNER JOIN DealersShows DS ON DSR.DealerShowID = DS.DealerShowID
INNER JOIN MemberList ML ON DS.MemberID = ML.MemberID
ORDER BY ML.Store#

My combo box that is located in the detail section of the form Row Source is
set as follows

SELECT DS.DealerShowID, DS.ShowID, DS.MemberID, ML.Store#
FROM DealersShows DS
INNER JOIN MemberList ML ON DS.MemberID = ML.MemberID
ORDER BY ML.Store#

I have the following properties for the combo box set as follows:
Control source = MemberiD
Column Count = 4
Column Widths = 0";0";0";1"

I have tried setting Control source to Store# and that did not work

Any ideas on what I am missing?

thanks TSharp