How do I create a form to query a query?

[rebfein]

Well it's been 6 1/2 months of design, setup, data entry and questions regarding this project for my boss.



I want to thank all of you for being so helpful with all of this. Can I ask you to help me one more time...

I want to create a form, based on a query, that will display a sub-set of information from the query.

The original table contains records of an ECO, ECODate, Model number, Old modification number, New modification number and a note field. All fields are set to text format, except for the ECODate field (set to date, formatted as Short Date). The modification fields have a lot of zeros, 'VOID' and other entries, so I set the query results to filter contain only numbers over '0.'
The original query contains records of the Model number, ECO, Old modification number and New modification fields.

I want to set up the form to connect to the query so that when the user enters the model number and hits the enter key; the data results (either on the form or in a separate table/display) will show all the ECO modifications for that unit.

Any ideas on how to do this. I'm asking now and searching Google after sending this off.

Thank you,

[ranman256]

open a query that looks at the form for the model

sub txtBox_Afterupdate()
  docmd.openquery "qsFindModel"
end sub

the sql for qsfindModel would be:
select * from table where [modelno]=forms!myform!txtBox

OR
better would be to just filter.
in a continuous form of data, enter the Model# ,press enter, this activates the filter

sub txtBox_Afterupdate()
If IsNull(txtBox) Then
   Me.FilterOn = False
Else
   Me.Filter = "[ModelNo]='" & me.txtBox & "'"
   Me.FilterOn = False
End If
end sub

[June7]

Review http://allenbrowne.com/ser-62.html

[orange]

June's suggestion is the go to reference for a flexible search form.
You may also find some helpful info in this free youtube video by Steve Bishop
Good luck