I've never really put that setting through its paces. I'm guessing --
just guessing -- that the setting may be factored to control how many
pages of records are fetched and examined, rather than controlling the
exact number of records. If this is so, then if reading one page gets
enough records to yield 150 unique values, so be it.
I'm not sure I understand what you're describing, but it sounds strange.
Sure, if your form is based on a query involving 5 tables, I can see how
it might just read a calculated number of pages from each table to see
what unique values are there. But I don't see why duplicating a bound
control on the form, or even adding it twice to the query (without
adding another table) would have an effect. Would you be interested in
e-mailing me a sample of this? If so, post back letting me know and
I'll tell you where and how to send it.
Dirk Goldgar, MS Access MVP
(please reply to the newsgroup)