Hi,
would be grateful for a bit of a steer in the easiest way of achieving the following
I want to have various text boxes and combo boxes on a form. The form will be linked to a table.
i want to be able to tab thru the form and when I come to values I deem to be an issue I want to be able to red flag them. Once the text box or combo box is red flagged it will then automatically turn the relevant field in the table red and then at the end of the form a button is there to generate a report of the items I have red flagged.
i am assuming I will need to use vba and just change the background colour of the text box / combo box? So if user does certain key stroke ctrl+shift+r? Then do I need to use vba to generate a report or does access allow a report to be generate by field colour