subform fills parent w/dbl clk

L

lmv

I have a subform (continous) "OrdersList" based on "productsTTL" table.
I would like to be able to click on the record ProductName field or use the
record select in "OrdersList" form and have it populate some fields in the
parent "OrdersTEST" form ie. ProductName on the sub would fill ProductName on
the parent but I don't know how. I have a combobox on the parent OrdersTEST
form BUT it is better if the person can see what they need to choose from the
LIST. So the subform becomes the list which is bound by categoryID so it is
only listing those things in that category.
Do I need to change the productname field on the parent to unbound?

In the dbl click event what would be the VBA to accomplish this.
Can it be put on the record selector or should I put a cmd button there?
Again what would the code be?


ALSO:
Could I leave it so they could use either option? Click on the subform or
use the drop down.
Right now my cbo on the ProductName in the parent is SELECT DISTINCTROW
[ProductID], [ProductName] FROM ProductsTTL ORDER BY [ProductName];

But it is not filtering by Category so you get the list of EVERYTHING in the
ProductsTTL Table I need it to filter by category?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top