paramaters

[davidf]

I have a database I built for keeping up with units. one form you enter unit info, the sub form you enter docs. I built a query with a parameter in the unit field as "Which Unit" When I run the report although it ask for Which unit it reports all docs in database not just under that unit. the unit table being master and the doc sub form being the child. relation on unit table and doc table are linked by " I need to have the report for the "unit" name I answer the parameter with. whats wrong. thanks for your time please help.

 

[JHB]

You have to link the two tables together in the query, by the same field(s) you have in the Main- and the Sub-form.

 

[davidf]

Yes i have a table called tracts, and a table called units in the query design view i check the relations and they are set unit to unit fields. it still pulls every doc.

 

[davidf]

You have to link the two tables together in the query, by the same field(s) you have in the Main- and the Sub-form.

Yes the two tables are linked i checked the relations it still prints every doc under all units.

Thanks I Got it fixed the relations were messed up thanks alot