Display Textbox value based on Combobox selection

[Twinnie]

Hello,
I am designing a Web Database with a bound form to a submit table.
On the form, I have a combo box with selections that should influence the value to be displayed in a textbox also on same form.
For instance the combo box for Staff Name contains list of all Staff and I want the textbox to automatically display the level of the staff that was just selected in the combobox.
I know how to get this done using a combobox but my boss insists that the level should be automatically displayed in the textbox once combobox selection is done.
Using the combobox for level, I used the select statement in the RowSource property : SELECT Staff_List.Level, Staff_List.Staff_Name FROM Staff_List WHERE (((Staff_List.Staff_Name)=[forms]![frmtest]![cboStaffName]));
I am in a dilemma of how to replicate this for the textbox because textbox only has control source and no RowSource where I can put this select statement.
Also, I will still need to bind this textbox to the submit table with the column name "TxtLevel" in the control source
Please see attached sample access db.
Also note that I cannot use action queries or VBA because it is a Web database and not a client database.
Thank you.


dbnew.zip

[ranman256]

from the example, I assume the cboBox BOUND COLUMN = 2 (staff name)
if so,

sub cboBox afterupdate()
   txtBox =  cboBox.column(0)
end sub

[Missinglinq]

sub cboBox afterupdate()
   txtBox =  cboBox.column(0)
end sub

You missed this:

...I cannot use...VBA because it is a Web database...

First off, for the Textbox on the Form, use The DLookup() function in the Level Control to pull in the Level for the given Staff_Name. Have a look at help and get back if you have a problem.

Secondly, unless you have an unusual requirement, you do not want to redundantly store the Level in a second Table! If you need to display the Level, later, simply use DLookup() again.

Linq ;0)>

[Twinnie]

Hello Missinglinq,

Thank you for your assistance.

Dlookup seems not to be available on Access Web Databases; please advise on alternative usage.

I am really in a fix on how to get this achieved. Newbie cryout I must say.

Please help.