big thanks an a beer if you do, seems a simple problem but its doing my head in. tempting to go back to Ver 1.2, but that's a problem with XP
Replace the Record Source property of the subform with this:
SELECT Item.Item, Item.area, Item.[plant type], Item.[commision date], Item.[supplyer codes], Item.statis, Item.notes, Item.Date FROM Item WHERE (((Item.area)=Forms!main!Combo0) And ((Item.[plant type])=Forms!main!Combo2));
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
brilliant, that works.Replace the Record Source property of the subform with this:
SELECT Item.Item, Item.area, Item.[plant type], Item.[commision date], Item.[supplyer codes], Item.statis, Item.notes, Item.Date FROM Item WHERE (((Item.area)=Forms!main!Combo0) And ((Item.[plant type])=Forms!main!Combo2));
BUT why? what bugs me is that in ver1.1 it was so much easyer
Sorry to bring bad news, but I'm not sure this is the complete answer to your needs.
If you need to add new records in the subform we will need to find another solution.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
No need for a new form
It can be done on this form, we just need to make a few changes. I've just tried it out and it seems to work fine.
Would you like me to post the required changes?
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Oh yes please
bear wood etc
OK
Try this out:
Remove the Master and Child Link properties because we won't need those after all.
Put this in the After Update event of both combo boxes:
Me.Item1.Requery
In the Default Value property of the textbox called "area" on the subform:
=[Forms]![main]![Combo0]
In the Default Value property of the textbox called "plant type" on the subform:
=[Forms]![main]![Combo2]
I don't think I've missed anything but if you have any problems, post back.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
brilliant, that worked well
if your in Adelaide that's a beer for you