Subform Query

N

Noemi

Hi

In the Form Header i have a combo box which has a list of id numbers, in the
Details section I have a subform which populates based on the id selected
from the combo box in the Form Header.

What I would like to do is only allow the details for that ID to be shown
and not allow the user to scroll to the next ID only if they select from the
combo box.

Is this possible and if so how do I do it.

Thanks
Noemi
 
S

strive4peace

Hi Noemi,

set the LinkMasterFields and LinkChildFields properties of the subform
control

LinkMasterFields --> controlname of your combobox

LinkChildFields --> controlname on subform that corresponds to the
combobox data

on the AfterUpdate event of the combobox:

me.subform_controlname.requery


Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Top