Hello, I am an intermediate access user. Any code that is on my reports I have done, I have received instruction help from other people.

My Question.
I have created a data entry form.
On this form, I have a combo box that filters the second combo box, limiting its choices. From there, the user fills out the rest of the form in a specific order. What I would like to do is this.
Have the label for the 1st combo box appear in red, then after the combo box choice is made, have the label for the 2nd combo box appear in red font, and so on.
This would help the data entry person enter the information in the correct order.
Or, could I have the labels for the combo boxes not be visible until information is selected in the previous combo box.

Thank You for your time, please let me know if I should provide more info.

---

Answer from Richard Rost:

In the OnCurrent event for your form (which runs when you move from record to record or open the form) set the label colors:

Label1.backcolor = vbred
Label2.backcolor = vbgreen

Then, in the AfterUpdate event for ComboBox1 you could say:

Label1.backcolor = vbgreen
Label2.backcolor = vbred

(or whatever colors you want).

Here's a tutorial I wrote which does something VERY similar (with filtering the combo boxes) and will show you how to use the AfterUpdate events:

I get asked this question all the time. You've got two or more combo boxes and you want the first one to filter the second one. I get asked this so much that I recorded a video tutorial explaining how to do it:

http://599cd.com/tips/access/two-combo-boxes?key=BlFAlEx