Subform challenge

[Parasyke]

I have a mainform named "SearchByManufacturer" that has a subform (in
DataView form)
named "Products Query Subform" which get its data from a query called
"Products Query"
based on a table called "Products" (Products and Manufacturers are in
this table).

I have a combobox on the mainform named "ComboManufacturer"
that pulls down a list of Manufacturers from a table called
"Manufacturers".

My first goal is to populate the subform with all the records of
products from the
respective manufacturer (specified in the combobox).

My second goal is to click on each line of that subform and populate
another subform
below it with details of each product.

My combobox works fine but it doesn't populate the subform. There are
records but they don't
change with the change in the combobox.

This and any help with my second subform would be a great help...

Thanks!

[Regan via AccessMonster.com]

>My combobox works fine but it doesn't populate the subform. There are

>records but they don't
change with the change in the combobox.

in subform data property

Link Child fields = Manfacturers
Link Master fields = ComboManufacturer

>This and any help with my second subform would be a great help...

Hope this helps

Regan

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200608/1