By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,410 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Populate child form after list box update

P: 2
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
Sep 11 '12 #1
Share this Question
Share on Google+
3 Replies


TheSmileyCoder
Expert Mod 100+
P: 2,321
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/insigh...filtering-form
And
http://bytes.com/topic/access/insigh...form-filtering

If you have further questions after reading those articles, please feel free to come back.
Sep 11 '12 #2

TheSmileyCoder
Expert Mod 100+
P: 2,321
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.
Sep 12 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.