Form Subform problem with requery

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"
 
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.
 
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.
 
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
 
Back
Top