Search results

I struggled with this as well, but have come to the conclusion that it cannot be done. Anyway about the ex, I know how you feel. lol

I want to run a query where I can enter two dates ( On on form ) and have a report show the results. I know I can write the dates in the criteria field in a query, but I want to be able to enter the dates on a form and do it this way. Please help, anything will help me, I hope. :confused: Thanks

Thanks for that These are not subforms. They are all separate forms with the one-to-many relationships. Thanks for your help though, I might even try and use them as subforms.

Thanks man I will try that and will get back to ya if I have any more problems let me put it another way, I have 5 tables and 5 forms. One main table is the Main form and the other 4 forms are connected to the remaning 4 tables. I have related them together as a one to many relationship...

:) I have a database with one main table ( Staff ) and 4 other tables related to this one table. I use a one-to-many relationship for all relationships. My problem is when I select a staff member on the main form and want to view the Mail that that staff have sent or received, the information...