How to show no info on Subform until Main form selection.

[Jack]

I have a main form with a subform that is linked using the child & master
fields.
The main form has a pulldown wich selects a persons name and then the
subform is updated with related info. This is working fine. However,
currently when the main form is opened it is automatically on the first
record even thought the pulldown is still blank(no selection). Therefore the
subform has related info showing for the first record.
My question is, how do I not show any info in the subform until a selection
is made via the Main form pulldown.

Thank you

 

[Guest]

It sounds like the main form is bound to a table and the combo box to a field
in the table. I think you could unbind the combobox and remove the
Master/Child binding to the subform. In the combo's AfterUpdate event, set
the subform's record with something like:
Me.sfrmMySubform!Form.IdField = Me.cboPersonsName

The idea is to have the combobox only be responsible for updating the
subform's record.

HTH,
Barry