Form Assistance Needed

[jaxmark]

I currently have an Access Database.

The database has a main form called RegionSearch.

The user is able to search 2 different tables. In the table on the left, they can search for zip codes or cities coming from "tblZipCode". In the table on the right, they can search for AOR Code (Agency on Record) from "tblAOR". There is a 3rd table, "tblMaintenance_Reps" where, based on the resulting AOR code search, the AOR has an assigned region (DelegatedToRegion). I want the 3rd table on the main RegionSearch form to show me all the reps from "tblMaintenance_Reps" where the DelegatedToRegion is equal to the same DelegatedToRegion in the AOR being displayed on the form.

I created a query called "qryCPIM_Rep_Assign" which is supposed to pull the field [tblAOR_subform].[DelegatedToRegion] but whenever I open the main form, I am prompted to insert the criteria for this field. I don't understand why it doesn't pull the data from the subform as stated.

Does that make sense?

 

[CJ_London]

please can you post your query - the chances are it just needs a syntax correction

 

[John Big Booty]

Welcome to the forum.

When you are dealing with a sub form you need to get the correct syntax for referencing it.

Probably something along the lines of;

Forms!Mainform!Subform1.Form!ControlName

 

[jaxmark]

Thank you!