Assign a value to a Textbox

[Murray]

Hi all
I have a sub form with 3 textboxes. I also have 3 employeeID fields on the
form that are set when a button is pushed eg
employeeID1 = 1
employeeID2 = 5
employeeID3 = 26
These values relate to a table Customers.id so that if customer.ID = 1 then
the name is Bloggs, if it is 5 then simpson etc. Is it possible to get the
textbox on the subform to show Bloggs if the employeeID1 = 1 and the next
textbox to show Simpson if employeeID2 = 5 etc.
Thanks for the help

 

[Alex Dybenko]

Hi,
you can use dfirst function to lookup customer name:
=DFrist("CustomerName","Customers","id=" & [employeeID1]

you can also consider to use a combobox

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com