I'm sorry, but I don't understand your question. Can you please elaborate?

I know was very complicated.  I have two tables one is for clients and another one is a product table this product tables has a couple of column that contain Product desc, Risk Value (numbers here from 1-10) and Risk Description (low, medium and high).
When I put in my members tbl Product I do a lookup wizard pointing the product table.  Now I do a query and when I select product I which bring the filed of Risk value is that possible? Because I cannot pulled so far.

Sounds like you're looking for an AfterUpdate event, but this might be beyond your current skill level. I'm still not 100% sure what you're trying to do. You want to edit your Member record by selecting a Product and then having it get the Risk Value for that Product and save it in the Member table? I would say you don't need to do that. Just join the two together and use a combo box. But without knowing the context of exactly what you're trying to do, it's difficult to help you.

Maybe I'm not following either. That combo is bound and storing the value of your ID in the table correct?

Then you want to make a query tell you what the risk value was based on that product ID picked in the combo? Why can't you just bring the relationship into the query?

If I'm not understanding right, this might also give you a nudge in the right direction. Make a new field in the query like this replacing your field names.

RiskValue: (DLookUp("RiskValue","ProductT","ProductID=" & [ProductID])

Should be this, not sure why it cutoff my NZ, that will return 0 on nulls (products with no risk value listed)

RiskValue: NZ(DLookUp("RiskValue","ProductT","ProductID=" & [ProductID]),0)

Part of the problem is that I don't know WHAT you want to do with this data? Please read my article on Context.