text box

[mnjohn]

hi


i have a table (tblnames) which has 2 fields that are ( id and name ).

then i create a form (frmnames) that has 2 text boxs..

textbox1 and textbox2...


now what i want to do is that when i enter id number in textbox1 the 2nd textbox should shows the name of that id which is on my table (tblnames).

and if i put name in textbox2 it shows the id of that relevant name...........

thanks

[ranman256]

use the afterupdate events. Notice the ID is numeric so there are no delimiters, and
to lookup NAME field, a string, it will require delimiters in the dlookup...

sub txtBox1_afterupdate()
   txtBox2 = Dlookup("[Name]","table","[id]=" & txtBox1)
end sub

sub txtBox2_afterupdate()
   txtBox1 = Dlookup("[ID]","table","[name]='" & txtBox2 & "'")
end sub

[June7]

That's fine as long as there is only one John Smith and user correctly spells name. Why not use a combobox?

Is ID an autonumber primary key? Why would user enter ID? Why would user even be aware of an autonumber primary key?

[ssanfu]

And "Name" is a reserved word in Access.
Reserved words should not be used as object names.

Unless this is for your personal use, how is a used supposed to know how to enter the name?
Options could be:
Jon Smith
J. R. Smith
JR Smith
Smith, Jon
Smith Jon (no comma)
Smith JR

Better to have FirstName and LastName or GivenName and Surname


Also, having the FirstName and LastName in one field violates "First normal form (1NF)"..... if you want to talk about normalization..