John So the row source is a query. When you open this particular query are you able to view the records in datasheet view? Click on build button next to the RowSource property and then on View Datasheet.
Regards Liveson ----- Original Message ----- From: John Young To: [email protected] Sent: Friday, 18 July, 2008 11:22 AM Subject: Re: [ms_access] empty combo / list box problem 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] [Non-text portions of this message have been removed]
