Add combo box to sub form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wonder if anyone can help. I have used the inventory control template for
my database but have run into a problem with the purchase order/p.o sub form.
I have added category and colour tables linked to the products table to make
it easier to select items when ordering. i therefore would like to add
something to the purchase order sub form so i can select a category and it
limits the product selection. I have tried adding cascading combo boxes -
category followed by product. I have managed the category drop down but cant
get it to populate the product list. Any help would be greatly appreciated.
Perhaps there is an easier way of going about this altogether?? Thanks.
 
Thank you so much for replying. I'll have a go at that this evening. I've
havent attempted a D Lookup yet - it never occurred to me to do it that way.
I hope you dont mind if I post back if i get into trouble?? Can I just ask
a quick question regarding this - the queries i have practiced with before
involving combos i did through the expression builder. without wishing to
sound completely dumb, why am i just typing this sql into the after update?
and also, what does the Dim strFilter stand for? I've seen it on quite a few
posts. Or perhaps you can direct me to a site where all this code malarky is
explained!

Thanks once again for your reply.
Best wishes
Jules
 
Hi Bruce. I dont wish to outstay my welcome but i have just one final
question for you - I was typing your code in and i realised that I dont need
to query the products by size - just by category and colour so, with regards
to your code, would i just not type in the Select * from CompanyColours bit?
Is the "CompanyColours" your name for your colour table? PS I will take you
up on your suggestion of utter access.
Best wishes
Jules
 
Back
Top