Combo Box Controlling a subform

[andyb7901]

Hey,

I have a combo box based on a table. It has two columns; The key which is hidden and the name of a location. On the form there is a subform which has a number of fields for equipment. This is based on another table. However, the tables are linked via a relationship. What I would like is when I select a locaton from the combo it changes the fields in the subform to match the location. Im not sure how to embed the query in my subform or how to take the ID from the drop down and embed it in some sort of global variable??

So Select * from tblEquipment where frm_Till-Equipment.combo_Location.Location_ID = 'Variable';

Thanks

[Rabbit]

Is the main form bound to a table? And is the combobox bound to a field in that table? If so, set the subform object's master fields to the field in the main table and set the child fields to the field of the other table.

Remember, the subform object, not the source for the subform, they're different.