help on my forms and subforms

[ChristieB]

Hi. I have a form generated from one table and a subform within it that
shows data from a different table. I need to generate a query or a filter
that will only show fields that fall within two dates on my subform. How do
I do this?

The form has employee Id information and the subform has information from a
table with time sheet information. I need the filter or query to only show
dates within a pay period. Thanks for your help.

 

[Klatuu]

Use a query based on the table for the subform instead of the table that
filters based on your pay periods.

 

[ChristieB]

I made the query that will get the dates that I want but it does not aply to
the subform when I build it as a command button in the form. Now it runs the
query but it's not connected to the form or subform.

 

[DM]

in the primary form, go to design view and either delete the subform or go
into the properties of the subform and reset the record source to the query.
note the drop down for this field shows all tables and queries so if the
query is named similar to the table, ensure you know the query name when you
select it.

also, did you set the parameter filter for your dates?

 

[DM]

forgot to mention that you will have to reestablish your links between the
child and master fields.