building subform

[Chip]

I have built a form that is directly pulls information
from a query. It also does calculations, forcasted orders
and sums in that form. It lists all of this information
on an item by item basis in a sort of Non-fixed column
crosstab/table appearance.

I am attempting to make this form be filterable. I have
been trying to turn this form into a subform that allows a
filtering form to be applied against it. based on criteria
that is shown in the original query (such as only one type
of inventory). My problem is simple. I am attempting to
do this by creating another form, and allowing the combo
box to filter out the criteria in the subform that
contains the advanced calculations. I have used the
wizard, and it is just not attaching to the original
form. The top form layer would be for filtering, and
adding a parameter that could display my calculated
number, yet apply a paramer that would be able to increase
or decrease the general forcast. Can you help in giving
me some suggestions on the basics of getting this combo
box and the advaced subform to properly attach?

Chip

 

[Kelvin Lu]

Instead of using a subform, just use the form you already have. I assume
your form is in the details section of the form. Put your search boxes into
the header of the form. I like using combo boxes with the criterias listed,
then in the after update event I apply the filter and requery the form.
This will filter out the stuff you don't want to show. I would also include
another button to remove the filter so that all the data can be seen again.
Let me know if you need instructions on this.

Kelvin Lu

 

[Kelvin Lu]

Contact me on my personal email with details of your project and I'd be glad
to help.

Kelvin Lu
(e-mail address removed)