Hi (Windows XP Pro, MS Access 2003)
I have a form that has quite a number of list boxes on it. The list boxes only have 3 or 4 selections possible...Pass, Fail, Average, Not Applicable. The form is used for recording many tests performed on equipment. At present as the tests are conducted, the user clicks on the relevant selection in each list box, then when done saves the results to a table.
What I would like to know is if it is possible to 'preload' a selection, so that when the form is opened, the results of the previous test will be shown in each list box but instead of in black color (such as they look at present when an item in a list box is selected) they will perhaps be gray or whatever.
This would mean that the user could compare how each test parameter result is now ,with how it was last time around.
Then when they made their selection for the current test this would be indicated as usual and when the new test was saved the correct results would be recorded?
As always any advise or tips appreciated.