How to make automatically

[Santiadji via AccessMonster.com]

Hai all,
Thanks for your support to me of my latest question, here I have another
question that need your help.
I have a table, name : tblworker, consist of two field : WorkerName & BadgeNo.
Then I make a form consist of two text box which link to both of tblworker
fields. When I type BadgeNo on the text box form, I want WorkerName also
automatically appear. How can I do that??

 

[Santiadji via AccessMonster.com]

Yes I understand it, I am sorry for not complete description. Well, actually
it complicated for me to explain cause I use subform on my form. Let say I
have two table 1st is tblworker and 2nd is tblStock. tblStock is put on the
subform. I put many text box on the subform from tblStock fields, two of it
are BadgeNo & WorkerName. The text box will be used by user to fill data.
Because of I have already tblworker so I want on BadgeNo text box user just
fill her BadgeNo then her name will be appear automatically on the worker
name text box, because if user shall put manual the name, it difficult due to
some user have long and strange name. How to link the badgeno and worker name
text box to tblworker then it will have also on tblStock??

Thankyou very much to you

Hai all,
Thanks for your support to me of my latest question, here I have another

[quoted text clipped - 3 lines]

of tblworker fields. When I type BadgeNo on the text box form, I want
WorkerName also automatically appear. How can I do that??

The description doesn't really make sense to me. You have a table, let's
say with 100 workers in it. BadgeNumber 12 exists in this table. You
have a form bound to this table and controls bound to the two fields.

When the user opens this form they will be looking at the first record so
the two controls for BadgeNumber and WorkerName will already have values
in them. Are you expecting your user to type over the existing
BadgeNumber? Why would they do this?

If the user moves to the blank "New Record" position they will now have
blank controls to enter data into. Would you expect them to enter 12
into the Badge Number control? Why would they do this if badge 12 is
already entered into the table? Won't this create a duplicate?

Is what you want actually a way to specify a badge number and have the
form navigate to the already existing record with that number? For that
you would use an unbound control that has some code that runs after it is
updated. The user woulf not type into the bound controls for that.

Please clarify your requirements.