help on my forms and subforms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChristieB - 14 Mar 2008 21:31 GMT

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.

Reply to this Message

Klatuu - 14 Mar 2008 22:09 GMT

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

Signature

Dave Hargis, Microsoft Access MVP

> 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
[quoted text clipped - 4 lines]
> table with time sheet information. I need the filter or query to only show
> dates within a pay period. Thanks for your help.

Reply to this Message

ChristieB - 14 Mar 2008 22:45 GMT

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.

> Use a query based on the table for the subform instead of the table that
> filters based on your pay periods.
[quoted text clipped - 7 lines]
> > table with time sheet information. I need the filter or query to only show
> > dates within a pay period. Thanks for your help.

Reply to this Message

DM - 15 Mar 2008 13:51 GMT

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?

>I made the query that will get the dates that I want but it does not aply
>to
[quoted text clipped - 18 lines]
>> > show
>> > dates within a pay period. Thanks for your help.

Reply to this Message

DM - 15 Mar 2008 13:59 GMT

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

> 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
[quoted text clipped - 26 lines]
>>> > show
>>> > dates within a pay period. Thanks for your help.

Reply to this Message