I have 2 cascaded boxes inside a subform:"Masterfrm". cmbOperator and cmb SiteName. Now cmbSiteName feeds on cmbOperator. When choosing an option from cmbOperator, the filtered list for cmbSiteName is available when working inside "Masterfrm". But when operating from the main form i.e. "Navigation Form", cmbSiteName asks for paramter query!. Below are the syntaxes..
Private Sub cmbOperator_AfterUpdate()
Me.cmbSiteName.Requery
Since cmbOperator feeds from a query, the criteria query builder for it is
[Forms]![Masterfrm]![cmbOperator]
Name of navigation control for Masterfrm form in Navigation Form is also being renamed as Masterfrm.
I am new to VBA please help.
Regards,
sunnyday