Linking data (1 Viewer)

[peterbowles]

Hi All

I have a text box where a use enters a number TextBox1

If the number the user enters matches the number in the table then the name that is related to that number appears in Textbox2

Thanks in advance

 

[pacsfo]

dlookup?

Try this in the afterupdate of textbox1 (assuming table has 2 columns: id, returnvalue)
Me.textbox2 = dlookup("returnvalue","table","idvalue = '"& Me.textbox1 &"'")

Or
can you just use a combo box fed from the table?