Queries involving subforms

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hopeing someone can help me here..

I have a main form with 1 subform, I want to make a query that returns data
for the main form, but using criteria from the related subform.

The problem i'm having is, if i use a normal select query based on both
forms, each record is listed as many times as the number of records in the
subform that match the criteria.

And of course if I group data from the subform in the query to limit the
records, it doesnt allow me to edit the data in the query.

Is there anyway to use criteria from a subform, but not actually include the
subform records in the query results at all? Or is there another way around
this?

Thanks for your help!


- Phil


.

Relevant Pages

  • Re: change text on tab based on data
    ... Any field in the criteria must be a field in the domain - in this case, ... Although I am not sure what this query is for. ... hand, if you have a query for each subform, then you don't need criteria to ... What I need to do is have each tab where the Record_ID is not null ...
    (microsoft.public.access.formscoding)
  • Re: Database Search Facility
    ... There is a generic "ad-hoc" report/query applet at ... > What I specifically want to do is construct a main form with a subform. ... > upper part of the main form will have criteria fields and a search button. ... > in the main form and linking them to a query. ...
    (microsoft.public.access.formscoding)
  • Re: Combo list dependant on main/subform field values
    ... In the RecordSource property of the combo box use a query that selects the ... In the criteria field of the query builder ... > I have a main form with a subform and a combo on the subform. ... > field txtSchoolID, bound to autonumber field SchoolID in tblSchools. ...
    (microsoft.public.access.formscoding)
  • Re: Suggestions Please - Subform Results Export to Excel
    ... --the name of the subform control ... --the query or table that is the record source of the main form ... now a parameter box appears requesting the ProjectID to base the query. ... Dim strSQL As String ...
    (microsoft.public.access.formscoding)
  • Re: Suggestions Please - Subform Results Export to Excel
    ... In your situation the form and subform are both based on the same table. ... Setting up the query with criteria like ... In the criteria row for ProjectID, ... Record Source: SELECT tblHours_Worked.ProjectID, ...
    (microsoft.public.access.formscoding)