combo boxes in subforms

[PabloGeek]

I have a main form for my 'jobs' and a subform where I want to input the data about what products were used on each job. I want to use one combo box to pick a certain supplier, and the next combo box to only display that supplier's products to pick from. I have a jobs table, a products tables and a suppliers table, with the key field from the suppliers table also in the products table. I have tried the 'where' clause in the underlying query for the second combo box but with no success.
Thanks for any help from anyone!

 

[james33]

Dear PabloGeek
You say 'with little success'
What error messages or results (i.e. lack of) are you getting from the setup you have at the present?

It might be an idea to tell us a little more about the relationships between the underlying tables and the Record Sources of your form and subform.
It makes it a little easier to answer your Question.
Regards Jim

 

[Guest_imported]

I have checked the forums and now the subform works, when it is opened on its own - ie the first combo box is used to pick the supplier ID in the products table, and the second combo box then only shows the products relevant to that supplier.
However, when I open the main jobs form, and use the subform, after updating the first combo box to the supplier ID, I get an error message as Access cannot requery the second combo box - it says it cannot find the reference to the subform in the code! So maybe it is a problem with subforms . . .
Thanks for the help.

 

[james33]

Dear MrsPabGeek,
cannot find the reference to the subform in the code.

Is the subform you checked the same one that is in the mainform (sometimes it gets really confusing with sfrms!)

Have you checked the after-update event code on the first combo box.
Post it here if you still can't see why

Also What version of Access are you using?

Regards Jim