Queries and Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I need to create a form that allows the users to run "Queries" which they
make up by selecting the values in drop down menus without running query
wizard? and then display the output to a subform on the mainform. i read
sometime ago that someone had already done this,,,, can anyone help...

Paul
 
The simplest way I know to achieve something close to this (except for the
subform part) is to use the built-in QueryByForm button.
If you really need to do more than that, you'll need to be comfortable
constructing your own SQL statements, especially WHERE clauses.
And I'd strongly suggest that you consider using controls (I like
multi-select list boxes) on the form, rather than drop-down menus.

Give it a go -
and feel free to post back with more detailed questions.
 
Back
Top