Subform Help

[egobbitz]

I am not sure if this has been covered, I looked up Subform but couldn't see it.
I have a form that I want to have a combo box that gets values from a table. I have a subform that lists the related records in another table based on the value in the combo box. I want the user to be able to select a value in the combo box and have the corresponding subform values to update to the new set of related records.

How do I do that?
Any pointers would be greatly appreciated.

Nick

 

[garfunkel41]

Hey Nick,

I'm a newbie who's not very sure of herself, but i think there's a pretty simple solution to this (that is, if I'm understanding you correctly).

Once you've created your two forms and placed the subform in the main one, select the entire subform and view its properties. Choose the data tab and in the "link child fields" text box, choose or type the name of the field from the table/query that your subform is based on that is related to the information in your combo box. Then, in the "link master fields" text box, type the name of your combo box.

Let me know if I confused you please.
garfunkel41