Drop-down menu items not all appearing in query

[joannehellen]

I have set up a very basic query to pull together various elements from several tables.



One table has 11 people in it, however when I run the query, only 10 of these appear in the drop-down menu of the query. This means that, if we want to change the person selection from within the query to this 11th person, it is not available for selection. Other items in the same query are displaying all items in their drop-down menu (some with > 20 items) so I can't work out why this one should be missing an item off it.

Any advice greatly appreciated!

[ItsMe]

You can adjust the RowSource of your combo by clicking the elipses(...) next to the RowSource field in the Property Sheet and using the query builder.