Report using criteria from a form

[jgonick]

I am building a directory of families. I need to be able to choose certain families to be included on the report. I've read faq703-2696 and have it working, but I can only select one family at a time. I would like to be able to select multiple families (from a combo box) and/or choose familes that start with a specific letter and/or by a date. (I am time stamping when I update info- so it would be nice to print out updated families.)

I'm sure this is all addressed somewhere in these forums, but I couldn't find it.

Thanks, for the help.

 

[dhookom]

You can't set a combo box to multi-select but you can do this with a List Box. Check faq703-3936 for some generic code.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[jgonick]

I've looked at it and I'm a little confused.

I've made the module, but I'm confused about the arguments.

I have the form going to a query (directory query) In the criteria of the query I have it being equal to the listbox (listboxwhoT).

 

[dhookom]

You can't use this directly in the query. You would use the where clause in the DoCmd.OpenReport line of code.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Peter425]

When using this approach, does anybody know hoe to prevent the query from adding a new record to the underlying table. In short, I can use the search to find records that meet three criteria usch as the unput into three different field, but if I keep running the report, I notice the output increase by one record each time, this record being the search criteria.

Thanks,
Peter

 

[dhookom]

Peter425,
I'm not at all sure what you are referring to. The solution that I suggested does not add records to any table. Are you sure you are posting to the proper thread?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Peter425]

Duane

My apologizes... I'm new to the site and posted my reply in the wrong location. It was intended to be in response to the procedure outlined in faq703-2696.

Thanks
Peter

 

[jgonick]

Got it done. Thanks for the help..