Combo Box on Form to select Query Criteria

[Guest]

I have a customized form based on a multiple-table query. The query is very
messy, so obviously I don't want to deal with it more than I have to. My
database is 100% reference only, no editing or inputting of data. My friend
suggested that I divide the form in half, top to bottom, and put several
combo boxes on the top half to select what records are displayed on the
bottom half. Right now, I am not sure how to do this, so I welcome any
suggestions there.

But also, are the combo boxes limited in the number of lines they will
display? Some of my fields have 2500+ entries and I'm worried I won't be able
to select them as needed - I read somewhere that Access may not display
everything if the list is too long.

 

[Arvin Meyer [MVP]]

But also, are the combo boxes limited in the number of lines they will
display? Some of my fields have 2500+ entries and I'm worried I won't be able
to select them as needed - I read somewhere that Access may not display
everything if the list is too long.

An Access combo box will display 64,000 rows
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access