Enter criteria and display in subform

  • Thread starter Thread starter BrookieOU
  • Start date Start date
B

BrookieOU

Here's what I would like to do...

I would like to have a form where a user can choose the criteria and the
results are displayed in a datasheet view I guess in a subform. I am pretty
sure I can set up the criteria part of the form. What I'm having problems
with is setting up the split/subform to display the data. Any suggestions?

Thanks,
Brooke
 
Brooke

One approach would be to use the criteria in the (main) form to dynamically
build a SQL statement (behind the form) that is then applied as the source
for the subform control.

Another alternative, if there aren't too many fields in the 'results', would
be to use a listbox instead of a subform, and again set the source for that
listbox to the dynamically-created SQL statement.

It would depend on what you have and what you want to do with it...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
There are 9 fields in the results. I would like to do whichever is easiest,
but I think I would probably be more comfortable with the first approach
since I'm not even sure I know what a listbox is.
 
Back
Top