Macro Results, How to filter?

  • Thread starter Thread starter Humbled Learner
  • Start date Start date
H

Humbled Learner

I have 2 tables, names, and assignments,
I have 2 forms, names and assignments,
I created a query in dataview to relfect the results of both tables, name,
assignment, refund amount and date.

I created a form for search. The form contains one drop down box which
contains the name from the table. After I choose a name from the drop down
list, the query will open in dataview with all the information in the tables.
I would like the query to open only with the rows which mach the drop down
box name I select.

Can I make a macro do this?

I would rather type the name in the search field and have the query results
show.

Thank You for any guidance...
 
You should be able to create a form with a subform bound to your query. Add a
combo box to the main form that allows selection of the name field. This
should actually be bound to the primary key from from the names table. Then,
use the Link Master/Child properties of the subform to filter the records
returned in the subform to the selection made in the combo box.
 
Back
Top