Form Subform problem with requery

[Tony]

I have a form with combo boxes for Location and SubLocation. On exit from
location I requery Sublocation. This works fine as long as I use it as a
form, but when I try to use it in a subform I get "You can't use the
ApplyFilter action on this window"

 

[demashqe]

Hi Tony,

Slightly Not Clear, How Did You Use That ComboBox In Your Subform.

Best Regard

 

[Tony]

For Simplicity sake I have as follows:

The Data/Row Source of the Location Combo Box is a Table of Locations
The Data/Row Source of the SubLocation Combo Box is a Query retrieving only
those SubLocations that equal the Location in the Location Combo Box.

 

[demashqe]

Tony,

I Understand that comboboxes but what i ask is how you are using tha
in subform.

did you place location *combobox * in main form and sublocatio
*combobox * in subform??????????
how did you link the subform with mainform?????????
is sublocation is query from location table or its stand alon
table?????????

all of that is need to solve your problem.

Good Luc

 

[Tony]

I am sorry that I am not explaining my problem very well, I am a little new
at this.


My subform is not linked to the form by either Location or SubLocaton.
It is linked by SerialNumber. A SerialNumber is picked in the Main Form and
a Service Description input screen is the subform.
In the SubForm a description of the service problem is entered and then
a Location of the problem is chosen *Combo Box* and then a SubLocation is
chosen *Combo Box* and then a cause is chosen *Combo Box*
I want only to be able to choose certain SubLocations after a Location
is chosen and only certain causes once a SubLocation is chosen.
A requery works fine when I use it as a form (Requery On Exit), but I
have an error when using it as a subform.

 

[Tony]

I responded earlier this morning but I have not seen it posted so I will try
this again. I am a new to this so forgive me for not giving you all the
information originally.

The main form "Serial Selection Form" and the SubForm "Record Input Form"
are linked by a serial number. The subform is an input area for service
problems relating to that serial number.

The SubForm has a Description text box, a Location Combo Box, a SubLocation
Combo Box, and a Cause Combo Box. The SubLocation Combo box uses a query on
Sublocations matching the Location and the Cause Combo box uses a query on
the Causes matching the Sublocation.

I hope this is what you are requesting.

Thanks