Filtering a subform

[Wildster]

Hi,

I'm trying to filer a subform so that whatever date appears within the text box tDate which is in the master form, only returns fields within the child form where the field tWeek matches the same value.

Is there a way of doing this?

Thanks

 

[Dennisk]

I would use a query for the record source of the subform and place filter criteria on the date referring to the value on your form.

=Forms!YourFormname!YourControlname

 

[Wildster]

Thanks for the quick response. If I used a query for the subform would this stop me from entering data within the subform?

I'm guessing it would as the text boxes would then become unbound in the subform. I need to still be able to input data into the DB via the subform. Is there a way of doing it like this?

Thanks

 

[Dennisk]

A query is a recordset and if it is from one table only then it is updatable. - experiment

 

[Wildster]

Didn't know you could edit a query, thanks very much that solves my problem.