create a form to filter iD, name, address in related table

[Httsampath]

1st table is press.
Feilds are [pressID] [pressname] [pressAddress]
2nd table is bookt
Feilds are [bookname] [booknumber] [auther] [registeredDate] [recipissuDate]

I need to use a form to filter those using
Comboboxes
Select [pressID]
Then automatically get the
[pressAddress]
[pressname] to the form

And

Filter data on [registeredDate] starting date and to date.. selecting on the form.

Please help me to how to do search those to a report useing one command button
Thank

[NeoPa]

Maybe Cascaded Form Filtering &/or Example Filtering on a Form will help you with this question. It's very similar to many others we've seen.

[Httsampath]

May be.. I will check .. thanks for the soon reply..

[NeoPa]

You're very welcome.

The benefit of using previous answers, especially a selected few, is that generally they are selected from many possible ones due to having full explanations as well as just the answers. This is particularly true for articles of course, where hopefully the explanation is the most important aspect of it.