Ok how to explain this (and hoping its the most appropriate forum) I have a main form which displays customer information, on that main form is a subform which displays service visits to the customers site. From this subform each month reports are generated for engineers to take along on service visits to the customers site.
Now for the problem, how can I display the previous service date on both the subform and the report? What I basically want is the previous service date, and then from this the next service date would be automatically generated (the form/reports already generate this) So really it's more for convenience that I want the previous service date to be also displayed. (I have not had a chance to try anything yet, so don't know if this is easy, or if I already know how to do it)
The customer information is saved in 1 table, with a one to many relationship onto the table which contains the service information. These tables are what the form/subform are based on. Hope this all makes sense, hope someone can help.
Thanks
Now for the problem, how can I display the previous service date on both the subform and the report? What I basically want is the previous service date, and then from this the next service date would be automatically generated (the form/reports already generate this) So really it's more for convenience that I want the previous service date to be also displayed. (I have not had a chance to try anything yet, so don't know if this is easy, or if I already know how to do it)
The customer information is saved in 1 table, with a one to many relationship onto the table which contains the service information. These tables are what the form/subform are based on. Hope this all makes sense, hope someone can help.
Thanks