Populate child form after list box update

[ramms1978]

I have Table called ALL it have 150 columns ,i need to populate these data based on main form filter,
filter 1) product cat
2) product name(multiple selection- list box),
3)year
4)type report.

after selecting this four fields.
tabbed form should populate with relevant products in data sheet view,
here i have ten tabs(pages ),i am using here one table only (All). any one of you please help on this, this is my first project on MS Access.
Thanks
Jay

[TheSmileyCoder]

Hej Jay, and welcome to Bytes

150 columns sounds to me like your data is not properly normalized. Please take the time to read http://bytes.com/topic/access/insigh...ble-structures. Its a very good article that will go a long way towards helping you master access.


I think the bases of your question comes down to form filtering, and as such I think you should try reading:

http://bytes.com/topic/access/insights/590551-example-filtering-form

And

http://bytes.com/topic/access/insights/893657-cascaded-form-filtering

If you have further questions after reading those articles, please feel free to come back.

[ramms1978]

http://bytes.com/topic/access/insigh...filtering-form

And

http://bytes.com/topic/access/insigh...form-filtering

this links not working

[TheSmileyCoder]

When I click the links in my post they work fine. Clicking the links in your post does not work. Just use the links in my post and you should be fine.