Originally Posted by
ranman256
Code:
sub cboBox afterupdate()
txtBox = cboBox.column(0)
end sub
You missed this:
Originally Posted by
Twinnie
...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)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007