I have an Access 2007 database where the parent table/form is for Unit Owner and the child/subform is for Visitors. The subform (located on a tab control of the parent form) functions properly, however it displays all of the visitors. In the Visitor table, there is a field for Out Date. I only want to show the current visitors on the subform. That would be any visitor record for that unit owner that has a Date Out of today or later OR when the Date Out field is blank.
Using the query as the record source to open the Visitor subform independently works only when I have the Unit form already open to a specific unit. If I open the Unit form, several popup windows occur (because I'm assuming the query has run and the subform doesn't have any data to display). Do I need to add code into the form's event properties? On Open, On Load, After Update, etc?
The subform contains the following fields: Visitor, Category, Date In, and Date Out. In the sample attached there are two Entry System forms. I am working on the one that ends in "FD" as well as the subform named VisitorSubform FD. The tables for UnitOwner and NotesVisitor link via the unit number. I need both versions of the Entry System forms to work. One will show all visitors, past and present, the FD version will only show those >Date() or is null.