Need to reset search form.

[rebfein]

Hi all,

I'm having an issue with a query & search form set that I'm hoping you can help with.

Background:
I created a database to track ECO changes (particularly Mods [a snapshot of a model in time]). I started with the current ECO information and am working my way back through them (for the past 15 years). So far, I've got 200 records in several tables. I want to get this particular issue solved and then I can pull in some other co-workers to back fill information for the past 15 years.

Issue:
I created a query and form with the idea that my boss could type the model no. in the form and have the records for that model appear in the query view. And of course, it's not working that way. It shows the results in the query, but only from running the search from the Query Design view. When using the Form View, a blank form appears:



The Design:
I created a table for the ECOs and Mods, which I combined with two other tables to form the ModQ query:


Here's the design for the form:




When I run the query from the design view, I get the following parameter value screen:


Enter a value and click on OK:


SEE NEXT POST FOR THE REST OF THE SITUATION...

[June7]

Controls used to input filter criteria must be UNBOUND, otherwise you change data in the record. Unless you use the 'filter by form' method. Search Access Help for filter methods.

If the query properly references the form control, there should not be a popup.

Your query looks like it is using INNER JOIN which requires related records in all tables for records to be retrieved. That might serve your needs. Actually, your table relationships don't make sense. You have specified primary key fields but none of them are linked to foreign key fields. You should be linking on primary/foreign key fields. Then apply filter criteria to whatever fields you want.

[HiTechCoach]

I would also recommend checking out this:

Search Criteria example