un-usual link in form controls

[29ramesh]

Is there any way to link two text boxes to the field of a table?

That is, i have a field called satisfaction

i have two text boxes tb1 and tb2
tb1 is linked with the field satisfaction(Control Source)
tb2 is linked by dlookup function (control Source)


when i enter code in tb1, tb2 would display the corresponding value "Good", "Poor","Bad", Worst" etc,

the requirement is instead of storing the code entered in tb1, i need the value in the tb2 to be stored to the table..

I hope, my problem is clear..

Please suggest me the solution..

[ranman256]

this is what combo boxes are for.
the combo would have 2 fields,
1, good
2, poor
3, bad

user picks the 1st column
txtbox2 can fill with the 2nd column. (no dlookup)
(note: in VB, columns begin with zero)

sub cboBox_Afterupdate()
   txtBox2 = cboBox.column(1)    'which is actually col 2
end sub

this would also run for existing records, in the ON CURRENT event of the form:

sub form_Current()
   
cboBox_Afterupdate
end sub

[29ramesh]

Thank you so much Ranman for your reply. still my problem prevails. the reason is i need to give input in textbox1. based on the input i gave in textbox1, textbox2 should make the label.
the scenario is for survey data entry. instead of making label entry or mouse click, i want to make numerical entry. The reason is, single numerical data entry would save my data entry time to a large extent. Is there way to achieve it?

[ArviLaanemets]

More detailed explanation.

You have in table e.g. YourTable a field Statistification, which can have values 1, 2 3, ...

On form, you'll have a control linked to this field. But instead of text box you'll use combo box (when you have a text box there, you can change it to combo box - right-click on control in design mode and change the control type);
In combo's propreties set Row Source Type to Value List, and into Row source field enter value pairs like 1;"Good";2;"Poor";3"Worst";... (maybe you have to change the delimiter there - depending on your Windows settings);
Also in combos properties set Column Count to 2 and Column Widths to 0cm;2.5cm

Now you can on form select Good or Poor or Worst, or start typing and combo offers those selections soon. In form you see texts, but in table are stored according numbers.

[NoellaG]

Hi,

if you'd like to see both the number and text: set column widths to 1cm;0cm and add a text box with as control source =MyCombobox.column(1)

[ssanfu]

when i enter code in tb1, tb2 would display the corresponding value "Good", "Poor","Bad", Worst" etc,

the requirement is instead of storing the code entered in tb1, i need the value in the tb2 to be stored to the table.

It sounds to me that the OP is trying to reduce typing and possible misspelling. He wants to type a 1 and have "Best" stored in the table.

- Could use a combo box with a value list: "Best","Good", "Poor","Bad". Just select the option (best choice).

- Could use VBA in the after update event to push a value into tb2.