I'm going nuts here:
I have a main form "SCParent" and 1 subform "SCSub"
The main form has a combo box for outlets. User chooses the outlet name from the box and the subform displays all records from that outlet. Parent and Child is linked through the Outlet ID#. This part is working just fine.
User needs to then choose a date on the main form using a date picker in a regular text box (which is set to default value today). I need the subform to display records from that outlet from that the date chosen.
The date picker is labeled txtDateFilter and the date field in the subform is labeled txtTicketDate.
I can't for the life of me figure this out, and think it should be pretty simple.
The main table combo box pulls from "Outlet" table and the subform pulls from 3 different tables, all linked with working relationships. The txtTicketDate pulls from table "Ticket".
Thanks in advance for your help!