How do you call two different sub forms based on the value in the combo box? One value gives one sub form, the other values give you another (different) sub form.
thanks. just what i was looking for. i'm told that placing the combo box in the form header and the rest in the details section is the normal way. do you agree?
Thank you for your video and explanation. Well done :-) - It didn't work immediately for me. I managed to solve it going to properties of my form in Data tab; I've inserted name of the combo box for the link master fields and the name of primary key of the other table connected to the table of the combo box - I hope it could help
Hi Leon, Quick Question... lets say i have a table with has multiple product names repeated multiple times and i wrote a query to get the count of each product repeated.... how can i link that data to a list box or a combo box? been trying to figure that out but not able to do so... if i fetch the details from the main table its giving me alot of information which is not so much useful to me.. all i want is the count of each product repeated number of times... that has to be displayed in the subform.. is there a way to do so? please do reply on thiss
The thought I had was, use the query to group and extract the count with the ID in a list and then have the list box use the query results as the source (use the wizard). I hope this helps.
@@LeonMarsden as you said that got group using the ID... if i do that i get the all the product names again... but the question here to group the product names and get the count and then display that in another subform or in a list box
I did make a form and subform in this video: th-cam.com/video/dWNeBJD7fH8/w-d-xo.html This tutorial is the best way to see how it works and then it follows onto the concept that you have looked at.
This is simply excellent. Thank you very much for the concise, easy to understand tutorial.
Thank you so much. You "Hit the Nail on the Head". Very clear explanation, especially helpful for this "past his best" guy! Cheers.
Perfect, well explained and concise. Thank you!
Thanks a lot...I've searching for this solution for a long time..you're my life saver
Very nice, brief and to the point, Thanks!
Concise, accurate, useful. Thank you.
Hope all goes well with your project. Thank you for your comments.
Excellent explanation!
I need to know to to show all records without filtering in the subform?
Thank you so much!
How do you call two different sub forms based on the value in the combo box? One value gives one sub form, the other values give you another (different) sub form.
Thank you for the knowledge, I hope you have a nice day !
thanks. just what i was looking for. i'm told that placing the combo box in the form header and the rest in the details section is the normal way. do you agree?
This is what i am looking for. But I might need 2 combo box. One for school year and for student. Any advise? Tnx
Thank you for your video and explanation. Well done :-) - It didn't work immediately for me. I managed to solve it going to properties of my form in Data tab; I've inserted name of the combo box for the link master fields and the name of primary key of the other table connected to the table of the combo box - I hope it could help
Same for me, thanks!
Great video and how can we print just these Filtered Records via a Report.
I did everything you did but still it did not work.. can you please show the table relationship structure? May be my disconnect is there
Thank you so much👍
Thank you man..!! It really helps me :)
Hi Leon, Quick Question...
lets say i have a table with has multiple product names repeated multiple times and i wrote a query to get the count of each product repeated.... how can i link that data to a list box or a combo box? been trying to figure that out but not able to do so... if i fetch the details from the main table its giving me alot of information which is not so much useful to me.. all i want is the count of each product repeated number of times... that has to be displayed in the subform.. is there a way to do so? please do reply on thiss
The thought I had was, use the query to group and extract the count with the ID in a list and then have the list box use the query results as the source (use the wizard). I hope this helps.
@@LeonMarsden as you said that got group using the ID... if i do that i get the all the product names again... but the question here to group the product names and get the count and then display that in another subform or in a list box
warlcok.sniper@gmail.com that's my email... i could show you much clear if we can get intouch.. this issue is killing me need help realy badly
@@kgopikkk This looks out of my wheelhouse now as I think you are going to need to use some VBA to populate the other pulldown list. Regards LM
In which previous video did you create the Form, "sfrmStudentEnrollment"?
I did make a form and subform in this video: th-cam.com/video/dWNeBJD7fH8/w-d-xo.html
This tutorial is the best way to see how it works and then it follows onto the concept that you have looked at.
well done,thanks...
helpfull, thanks