SubForm Headaches

[matethreat]

Hello Everyone,

I have a subform problem that's got me beating my head against a wall. I will try my best to explain it and hopefully someone can help.

I have a subform who's data is controled by the value of a text box, which isn't my problem.

This subform is meant to give the user the ability to create a list of materials required to complete a job. I want the subform to store information in a 'JobMaterialsTbl table, again which wouldn't be a problem EXCEPT: I have 3 fields in the subform that I want the data to be extracted from another table 'InventoryTbl.

This 'InventoryTbl has 3 fields 'ItemNumber , 'Description , and 'Price. What I would like to happen is the Description box would be a combo box, and when the item is found it would automaticaly populate the 'ItemNumber and 'Price and have each entry stored in the 'JobMaterialsTbl.

Does anyone have any ideas.

Thanks,

Aaron

 

[PHV]

Take in the FAQ area of this forum. An entire section is devoted to combo.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[matethreat]

I have read the FAQ's and played around a little more. Doing it on a form doesn't seem to be to much trouble at all. But doing in a Subform does not seem to be quite as easy.

I still haven't found a solution.