How do I display the results of a query in an existing form?

[Maniceye]

I'm creating a new query using QBF in an existing database. I'd like to
display the results by re-using an existing form which is already used to
display unfiltered data. Can anyone tell me how to do this?


Thanks for your help.

 

[Tom Wickerath]

Hi Maniceye,

Perhaps this sample will be useful to you:

http://www.accessmvp.com/TWickerath/downloads/customdialogbox.zip

More advanced forms of QBF, where one is creating the WHERE clause of a SQL
statement in VBA code, can be found here:

http://www.accessmvp.com/TWickerath/downloads/elements.zip

http://www.accessmvp.com/TWickerath/downloads/Chap08QBF.zip

http://www.seattleaccess.org/downloads.htm
See the download "Query By Form"
Tom Wickerath, February 12, 2008


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________