@weat010 - sorted: how to get outputs of both combos displayed in a form (Having got second combo to be filtered depending on first combo's selection as per this video)
After update your second combo box to open a form based on another, new, query: this query has all the fields you want on your form, but in the two fields that your combo boxes are concerned with, add as criteria [Forms]![NameOfFormComboIsIn]![NameOfFirstCombo] and the same for the second field,using name of your second combo.
Brilliant, but...having created a lovely combo box...how do you get the choice of value in the combo box to deliver the (filtered) results???. eg if the user chooses "single", how do you get a table/ form to appear showing only those results that are single CDs, ie filtered ???
I've not tried it, but if I was attempting to do as you were I would add an extra field to my CD table, call it something like ImagePath, and store the path to the CD image as a text (for example "C:\CD Images\0101.jpg"), then you should be able to set that image to display when you change the record by playing around in VBA. Hope that helps.
Yup its helpful
Thanx
waseemkhansahab 2 months ago
@weat010 - sorted: how to get outputs of both combos displayed in a form (Having got second combo to be filtered depending on first combo's selection as per this video)
After update your second combo box to open a form based on another, new, query: this query has all the fields you want on your form, but in the two fields that your combo boxes are concerned with, add as criteria [Forms]![NameOfFormComboIsIn]![NameOfFirstCombo] and the same for the second field,using name of your second combo.
weat010 1 year ago
Brilliant, but...having created a lovely combo box...how do you get the choice of value in the combo box to deliver the (filtered) results???. eg if the user chooses "single", how do you get a table/ form to appear showing only those results that are single CDs, ie filtered ???
These are the best videos on access on the web.
weat010 1 year ago
Thanks a lot!
odelb 1 year ago
thanks. it helped
JointBuster 1 year ago
Great work, truly appreciate the effort, thanks
97grad 1 year ago
@Firchild
Ah, okay, only up to 2.13 so far, will watch out for your method when I get to 2.22. Thanks. : )
blahdelablah 2 years ago
thanks for the tutorials, very fast and efficient, and wales run the rugby... what more could you want!! haha alan in rotterdam
paultje2small 2 years ago
@blahdelablah Look at video 2.22, it's all there
Firchild 2 years ago
@yetanotherstatistic
I've not tried it, but if I was attempting to do as you were I would add an extra field to my CD table, call it something like ImagePath, and store the path to the CD image as a text (for example "C:\CD Images\0101.jpg"), then you should be able to set that image to display when you change the record by playing around in VBA. Hope that helps.
blahdelablah 2 years ago