Cascaded combo box asks for paramater query in main form although it works fine in sub form

**sunnyday** · 12-07-2014, 08:05 PM

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

**June7** · 12-07-2014, 08:38 PM

See if this helps https://www.accessforums.net/forms/t...orm-32053.html

**sunnyday** · 12-07-2014, 10:03 PM

Thanks!! Problem solved. The Syntax used is

Like "*" &[Forms]![navigationForm]![SubForm]![ControlName] & "*"

Cascaded combo box asks for paramater query in main form although it works fine in sub form

Thread Tools

Cascaded combo box asks for paramater query in main form although it works fine in sub form

Similar Threads

Dlookup works fine on form, but not on report

Cascading Combo Box works in main form but not in a Navigation Page

List Box - On dbl Click - Opens record - Asks for paramater?

Trying to run a query with input from a form, query works fine but the form doesn't

Cascaded comboboxes in a form

Posting Permissions