I want when I click on specefic field I want the action that sepecfic record set only but not on the whole column.
Let me say briefly, but dont ask why all this.
I have set of colours in a table (ColorsSetT)
ID from this table will be saved as foreign ID in different tables like categories, for report headings, for forms, application setting table etc.
User will be able to change this (foriegn id) and can save it with user sepecefic ID, so it might be different for different user. (But this is later stage).
At the moment question is very simple. With the following code, on field click it changes the whole column background colour, rather than it should change where I clicked (specefic field).
Demo form looks like this, forget content of form. I am concerned with code at the moment. thank.
Three screen shots of form, (No click, clicked on 65280, and 0)
In image 1 was not clicked, Image 2 was clicked on highlighted (65280 color code) , Image 3 was clicked on 1st record (color code 0)
I can see colors codes are working and being picked up, but only problem is why is it applied to whole coloumn? why not to that clicked fieled only?
I also want to apply this on "form on load" event, based on ID of the colour.
Any suggestion, how can I change this for a continuous form. On a single form this is not a problem.
I also have tried sql record set but that also did not work either.
Thank you.
Let me say briefly, but dont ask why all this.
I have set of colours in a table (ColorsSetT)
ID from this table will be saved as foreign ID in different tables like categories, for report headings, for forms, application setting table etc.
User will be able to change this (foriegn id) and can save it with user sepecefic ID, so it might be different for different user. (But this is later stage).
At the moment question is very simple. With the following code, on field click it changes the whole column background colour, rather than it should change where I clicked (specefic field).
Code:
Private Sub txtColorCodeDec_Click()
Dim ColorSet As Variant
ColorSet = DLookup("ColorCodeDec", "ColorSetQRY", "ID_ColorsSet =" & Me.txtID_ColorsSet.Value)
Me.txtColorCodeDec.BackColor = ColorSet
End Sub
Three screen shots of form, (No click, clicked on 65280, and 0)
In image 1 was not clicked, Image 2 was clicked on highlighted (65280 color code) , Image 3 was clicked on 1st record (color code 0)
I can see colors codes are working and being picked up, but only problem is why is it applied to whole coloumn? why not to that clicked fieled only?
I also want to apply this on "form on load" event, based on ID of the colour.
Any suggestion, how can I change this for a continuous form. On a single form this is not a problem.
I also have tried sql record set but that also did not work either.
Thank you.