Enter criteria and display in subform

[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

 

[Jeff Boyce]

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

 

[BrookieOU]

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.