In an Access 97 database,I have a form with a combo box which I populate with one of two queries at run-time. Both queries are parameter queries and the query which runs is decided by which button I click in an option group.
If I run both queries outside of the form (ie as straight queries) they work fine and give me the subset of records relating to the parameter. If I run them within the form, and the number of records is 50+, one query gives me the full subset in the combo box (at least up to 200 records)but the other only gives me the first 50 records or so. I use VBA to indicate which query should run (....Recordsource = qry... etc), otherwise the coding is identical. Any ideas welcome, please.
Steve House
shouse@icaew.co.uk
If I run both queries outside of the form (ie as straight queries) they work fine and give me the subset of records relating to the parameter. If I run them within the form, and the number of records is 50+, one query gives me the full subset in the combo box (at least up to 200 records)but the other only gives me the first 50 records or so. I use VBA to indicate which query should run (....Recordsource = qry... etc), otherwise the coding is identical. Any ideas welcome, please.
Steve House
shouse@icaew.co.uk
