Selecting from the results of a Parameter Query (2003)

[Francois]

I don't understand why setting a filter would trigger a requery.
Can you attach a stripped version of your db ? (without sensitive data)

[Francois]

Ok, I was working on my pc with access 2000. I had no problem.
Just tried the db I send you on a pc with Access 2003 and I have the same problem, asking for the parameter.
This is an Access 2003 problem. I'll try to find a solution.

[iandouglas]

I've just spent a frustrating 30 mins trying to strip the db down under the 100K limited zipped & failed - 209K is as far as it will go. I'm pleased I don't have to

[Francois]

Sorry for having waste your time with the stripping of the db.
I have a workaround.
I build a form frmParameter with one textbox asking the parameter and a button to open the form.
In the query I set a criteria to >[forms]![frmparameter]![text0]
With this system the parameter is not asked every time you select an alpha character.
Do you think you can modify your db with this workaround ?
In attachment a sample db, just open the form frmParameter

[charlotte]

Must you actually filter the form, or would a means of navigating to the first item in the "Ps", for instance" be enough? I'm attaching a sample that allows you to do that. It was built in 2002 and is in 2000 format, but it should run in 2003 if you replace the reference to the Access 10.0 object library.

[iandouglas]

Francois

Yes thanks a lot it, now works just as I wanted with the really neat alphabetic selector you provided. Thanks once again!

Ian

[iandouglas]

Charlotte

Thanks for your suggestion. With Francois's help I got his elegant alphabetic selector to work with the advice he gave above.

Ian