Hi,

Im using square bracketed parameters in my query designs for user prompts. Now I want a similar feature to tell the query what field I want it to show. Is there a way of doing this please? - or does the fact I need to do imply a db design flaw?

There are several examples on Roger Carlson's web site here, from intermediate through to advanced level. (http://www.rogersaccesslibrary.com/TableOfContents3.asp#C)


this looks like the most applicable one! (http://www.rogersaccesslibrary.com/download3.asp?SampleName=CreateQueryFields.mdb)

Thanks :)

I had a look at the site (of which I may make well make some use sometime) but in the meantime I've structured my tables better so I can get the result in a simpler manner.