I don't understand how to implement this idea:
I put an unbound combo on the main form that allows to select the product.
Then how do I "set the Subform's Master Link Field to include this control,
and its Child Link Field to include the ProductID". I don't understand this
statement.
John Vinson wrote:
>>I have a form that captures a lot of information on actions involving
>>different products. This information is organized in a datasheet subform
>[quoted text clipped - 7 lines]
>>I think the latter option my be more do-able but I don't know how to
>>implement it.
>
>You might want to filter the subform to show only the records for a
>selected product at a time. One way to do this would be to have a
>control - a combo box or listbox perhaps - on the mainform allowing
>the user to select which product they wish to see; set the Subform's
>Master Link Field to include this control, and its Child Link Field to
>include the ProductID.
>
>This would have the advantage of not requiring any code.
>
> John W. Vinson[MVP]
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200509/1