I have a table where I store the specifications of the object. There are 6 specifications, 4 of which are combo boxes and 2 are textboxes
The combination of these 6 values needs to be unique. I therefore added an ComboCode in the table to store the conjugated values of these 6 textboxes and set the validation of this combo code
To store this combination of 6 text boxes, I added an unbound text box with a formula =[Txtbox1]&"-"&[Txtbox2]... [txtbox6]. This unbound text box control name is txtCombo.
The question is optimal way to transfer the txtCombo value to ComboCode. One way is to add the expression combocode = txtcombo in the AfterUpdate event of all the 6 text boxes. This does the job but I need to set the values 6 times in the form. This gets more complicated with some objects where the number of text boxes are higher
I added this expression in the On Change and AfterUpdate event of the txtCombo unbound text box and 'On Dirty' event of the form without result!
I also tried a control button with the code as below without any result
If me.dirty = True then
combocode = txtcombo
Endif
me.dirty=False
The combination of these 6 values needs to be unique. I therefore added an ComboCode in the table to store the conjugated values of these 6 textboxes and set the validation of this combo code
To store this combination of 6 text boxes, I added an unbound text box with a formula =[Txtbox1]&"-"&[Txtbox2]... [txtbox6]. This unbound text box control name is txtCombo.
The question is optimal way to transfer the txtCombo value to ComboCode. One way is to add the expression combocode = txtcombo in the AfterUpdate event of all the 6 text boxes. This does the job but I need to set the values 6 times in the form. This gets more complicated with some objects where the number of text boxes are higher
I added this expression in the On Change and AfterUpdate event of the txtCombo unbound text box and 'On Dirty' event of the form without result!
I also tried a control button with the code as below without any result
If me.dirty = True then
combocode = txtcombo
Endif
me.dirty=False