i want to have a form which, after a job number is entered show a single bar graph of the time taken for that job (DLookUp ed from a query / Table). For example, if the total time is two hours and the job takes one hour, half the bar would be coloured in.
i can do it by opening another form once the job number is entered but I'd rather like the form to be "live" - once the job is entered the colouring in of the bar happens AfterUpdate.
I don't feel as though I've explained this very well.
I hope someone can help.
Steve
i can do it by opening another form once the job number is entered but I'd rather like the form to be "live" - once the job is entered the colouring in of the bar happens AfterUpdate.
I don't feel as though I've explained this very well.
I hope someone can help.
Steve