DropDown Box

[Ry]

ACCESS 2007 User
I created a drop down box that changes color based on what you select in the
dropdown box. I did this by selecting the dropdown box, right clicking and
selecting Conditional Formatting > set it to Equal to - green show the
background color green, etc... well now when I go to create a new record if I
change whats in the dropdown box it changes it for the first record to.

How do I get this to change for just the record I am on?

 

[Linq Adams via AccessMonster.com]

Is this combobox bound to a field in your form's underlying table or query?
If it's not (if it has nothing in its Control Source Property) then the
formatting (color) for the comboboxes in all records is going to be the same
as it is for the last record.

When a control is unbound, each record doesn't have that control on it, but
rather an instance or copy of that control on it.