Liverson
Yes ...I can see all relevant records in data sheet .....
that has been no problem ....
every thing works fine ...setting appear correct all
querys/ tables can bee seen in data sheet format
but only a single name is displayed in drop down control
when you click on a "blank" drop down list
cheers
John
At 05:52 PM 18/07/2008, you wrote:
>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: <mailto:ms_access%40yahoogroups.com>[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><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]
>
>
[Non-text portions of this message have been removed]
