Subform Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
*
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filter query on combo box in a continuous subform 0
link in subform for 2 fields 4
Cascading Combo Boxes in a continuous subform 1
Filtering a combo box on a subform using a value from the main for 3
First Subform record gets modified when closing form 3
help with subforms and combo boxes please!! 4
Problems Linnking a SubForm 4
Error when using subform 2

Back
Top