Combo Box on Form to Feed Information Into Subform

[DaveAP]

I'm trying to use a combo box list to populate the subform information.

The form uses a name list from a table to determine which Representatives
the auditor wishes to audit. The subform shows a table of the percentage at
which the Representative gets audited.

For example:

Dave is selected in the combo box, the Percentage Audit table shows seven
columns at which he is audited:



Form 1: 25%
Form 2: 5%
Form 3: 100%

etc...

Then the auditor knows which auditing form they need to use according to the
results of the query.

I cannot seem to link the combo box to requery the subform each time a
different representative is selected. This is the code I've tried using:

Private Sub RepName_AfterUpdate()
Me.frmPercentage_Audit_subform2.SourceObject = "Percentage Audit." &
Me.Startup_QA.RepName
End Sub

RepName is the name of the combo box. Please help if possible.

 

[Jeanette Cunningham]

DaveAP,
maybe the syntax is not correct for the subform.
To refer to a subform you must use the name of the subform control.
In case you are not aware of this, a subform is always inside a subform
control.
The name of the subform control is not always the same as the name of the
subform.

There are also correct ways to refer to subforms from the parent form or
from another subform on the same form.
There are some tips at this site on
Refer to Form and Subform properties and controls
http://www.mvps.org/access/forms/frm0031.htm


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia