I had to create a db with a 1:many relationship of date:on call personnel. (short date format)
I used a wizard to create the form that is to be published for use throughout the building.
On Open, the date is always 1/1/2005; I want the form to consistently open to today’s date. I tried Control Source=Date and table.date() and it still starts at 1/1/2005. Without using filter by form or filter on date data element, how do I get the form to open on the correct recordset of today’s date?