Displaying records.

F

Farooq Sheri

This refers to Access2000. I want to display records in a table which match
some criteria. The records are in a table which has 5 columns. There are more
than 1 instance of this match and these are spread over 4 columns. The 5th
column is the field I am interested in. I want the values of this field to be
displayed in a tabular format on a subform for all instances of the match.
The matching criteria comes from the main form.

Thanks.
 
J

John Vinson

This refers to Access2000. I want to display records in a table which match
some criteria. The records are in a table which has 5 columns. There are more
than 1 instance of this match and these are spread over 4 columns. The 5th
column is the field I am interested in. I want the values of this field to be
displayed in a tabular format on a subform for all instances of the match.
The matching criteria comes from the main form.

Thanks.
Click to expand...

That's a very vague question, but...

Create a Query based on your table.

Use critera like

=[Forms]![NameOfYourForm]![NameOfAControl]

on the four fields (tables don't have columns... they are NOT
spreadsheets), using OR logic or AND logic as appropriate.

Base a Form on this query. Use it as the subform and Requery the
subform in the afterupdate event of the control.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top