Date Query

[Coach Ty]

Hello,
I'm working on an extensive data base and I've created the forms and subforms to bring up ranking information, in various categories.
The information is dated with the dates of each evaluation.
What I need to do is create a control that will return only the information for a specified date, in the subform.
Can anyone tell me what the procedure would be to create this control for my forms, to control the display of the subforms, contained in these forms?
Thanks for your help!

 

[HiTechCoach]

I am not sure I follow what you are wanting to do.

In general, a control on the parent form can be used as the master linking field property for q sub form control. The sub form will use the child linking field propery of the sub form control tol filter the sub form's to records that have a matching value in the control on the parent form (master linking field property).

 

[Coach Ty]

Hi,
Thanks for your response.
What I have is a subform, within a form, that is based on a ranking query.
The subform is in a data table format. The ranking query has a date field. So that every time the ranking query is done, an evaluation date is associated with the date the query was ran.

What I would like the form to do, is to return only one specified date of information in the subform, for review.

I just don't know how to program a control to execute an update, for the subform to return only the specified date of information?

 

[Anchoress]

So you want to filter the results in the form to show the just one date?

 

[Coach Ty]

Yes, just to filter one date of evaluation results.