I apologize for the lame heading but I don't know how to explain it.
I have a table with a name, Red, Green, Blue fields
The Red, Green, Blue fields are the three numbers i'm using to make up the color I want (Blue= 173,192,217)ect...
I have a continuous form that has a single text box. The control source for this textbox is the NAME from that table
The continuous form works great.
All I want to do, is click on a Name and change the background of that SINGLE record to the Red, Green, Blue fields to makes up the single color
Current Code is:
Me.txt_Name.BackColor = RGB(Me.Txt_red, Me.txt_green, Me.Txt_blue)
I have txt_red, txt_green, txt_blue as test boxes (control source to the table of course) as well and those are what is being referred to in the VBA code.
But this changes the color of ALL the records, not just the single record im on.
Suggestions?
I have a table with a name, Red, Green, Blue fields
The Red, Green, Blue fields are the three numbers i'm using to make up the color I want (Blue= 173,192,217)ect...
I have a continuous form that has a single text box. The control source for this textbox is the NAME from that table
The continuous form works great.
All I want to do, is click on a Name and change the background of that SINGLE record to the Red, Green, Blue fields to makes up the single color
Current Code is:
Me.txt_Name.BackColor = RGB(Me.Txt_red, Me.txt_green, Me.Txt_blue)
I have txt_red, txt_green, txt_blue as test boxes (control source to the table of course) as well and those are what is being referred to in the VBA code.
But this changes the color of ALL the records, not just the single record im on.
Suggestions?