I know it is taboo for the user to print from a form. However we have found it works best for the use we have.
The DB is a maintenance ticket program. When the user prints it prints on a 1/2 sheet of perferated paper. The form is the perfect size to do the printing.
When I originally created this form I stored the data wrong. One of the fields was saving a name not the ID. However this was working for the what we needed. Now we need to search for the records. I relized what i done and changed it to pass the ID not the name. Now when the users do multiple records AKA Tickets it prints all the data correctly exept the name.
If the name is Test on record 1 and you create a new record and the name is Office. All appears well on the screen as it should but, Then when you print the records both will be printed as Test.
However when you look at the table it saves the id’s correctly.
It seems to work correctly with no glitches if you tab through all the fields but if you hit enter instead then when you print it prints wrong. Maby this is just a coincidence but thought I would throw that out there as well.
I dont want to change the way we do this unless I absolutly have to.
Any ideas?
