i have a database that has a navigation form set as the start up screen. (Navigationform)
In that form other subforms are displayed. All works fine to navigate through all the forms and reports and each form or report behaves correctly.
However on the report form there are several sub forms created to view data. I created a query which uses the start and end function to set a date range for the query. This query is then displayed as a datasheet in a subform on the reports page. The resulting data is being displayed on the subform correctly, the date i have set in the query works fine. However now when I open the database it starts at the navigation form which is correct but i am asked to enter the first and last dates before i can view the navigation form. NOT what I want!
In an earlier version that i made before i added the start and end query to the subform the database opens correctly without asking for the start and end times.
I am new to this and i cant understand why this query is being applied to the navigation form. This is the only time I am asked for it.
TIA
Peter nfbo