Editing subform columns from main form combo box

[Devwer]

Hi!
I'm trying to figure out what I need to do in order to use a combo box to edit a subform from the main form. Here's a picture:



Basically, when I enter new Items, I want to click on the combo box to define which Mineral, then enter the Quantity in the text box. It should also display the quantity, if it already exists. As it stands, the combo box has the lookup list, but I can't figure out how to integrate it like I want.

Here's how everything's related:

And here's the table datasheet:




I'm entering new items manually this way, but I would like to have a drop down box instead of typing it out each and every time. Perhaps I'm going about the form all wrong. Any ideas?

[hertfordkc]

clear what you've tried so far, which it probably why you haven't gotten any answers. So I'll offer an observation or two.
Selecting variables on the main form won't necessarily requery anything. In other words, you could select something that was already in the tables, but the form or subform would not look for it unless you do a requery. One thing you could do is have the 'onclick' event of your listbox or combobox alter or set a filter and do a requery. I'm talking about VBA code for this, but again, you can probably get results through the expression builder or macros.
If the subform needs to requery, you will probably need to set the filter for the subform to refer to a (hidden?) textbox in the main form. I believe I've had problems trying to simply set the filter for the subform.
You'll have to provide more detail to get any real help.