Liveson the row Source is : SELECT Members.MemberID, Members.Surname FROM Members ORDER BY [Surname]; Control Source is : Surname
At 04:28 PM 18/07/2008, you wrote: >John > >If you go to the properties of the combobox and open the RowSource >are you able to view the records in datasheet view? What I want to >find out is whether the problem is with the combobox itself or with >its row source. > >Liveson > >----- Original Message ----- >From: John Young >To: <mailto:ms_access%40yahoogroups.com>[email protected] >Sent: Friday, 18 July, 2008 3:48 AM >Subject: [ms_access] empty combo / list box problem > >I have created a form with a combo box and cannot get it populated, I >then created a list box and have the same problem..... >I have done this before without any problems, but for some reason this >time nothing....... >I have created both boxes with wizard and without wizard..... >I get a single name in top section of box but the drop down section is >empty... >If I click on the blank section of drop down area I get a name in the >top section and this varies depending on where I click .... but I do >not have any idea whos name I am clicking on.. > >I have looked at other forms that work properly and compared setting to >no avail... >Any Ideas or where have I gone wrong..???? > >Cheers >Kohn > >[Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed]
