I have built a database for my service business, in which I enter all the service orders as they come in. They come in sometimes up to two months in advance of the actual date of service. When I open the form, is there a way I can open it up to today's service date, or in lieu of no scheduled service calls for today's date, to the next sequential date where we do have a service call?
Currently, I have it set up to open at the last record, however, then I have to use the search feature to bring it back to today's date.I have searched the forum up and down, but can't seem to find the right help. Can anyone shed some light? Please bear in mind, there could be multiple records with today's date, or none at all.
Currently, I have it set up to open at the last record, however, then I have to use the search feature to bring it back to today's date.I have searched the forum up and down, but can't seem to find the right help. Can anyone shed some light? Please bear in mind, there could be multiple records with today's date, or none at all.