Populate text box based on entry in another text box

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello, I'm trying to set up a form in which if a user types a product code
into one text box, in the next text box the product's description is returned.
Here are the fields and controls involved.

[EXCEPT PROD CODE1]...control name is Text260 (I'm very new at developing
these things, so I never got around to renaming the controls)...this is where
the user would enter a product code

[EXCEPT PROD DESC1]...control name is Text227...this is where the description
would automatically be filled in based on the product code entered in the
previous text box

I'm thinking DLookup might be the answer, but I'm having trouble grasping
this. I do have a table listing the product codes and descriptions, which is
named Z006. I need to know in which controls to put the code, which events
in the control should have the code, as well as the syntax.

Any help is most appreciated...thanks!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200511/1
.

Relevant Pages

  • Re: Populate text box based on entry in another text box
    ... AimeeK wrote: ... >John, Thank you for your reply...however, I can't do a combo box because we ... I'm trying to set up a form in which if a user types a product code ...
    (microsoft.public.access.queries)
  • Populate text box based on another text box entry
    ... I'm trying to set up a form in which if a user types a product code ... Here are the fields and controls involved. ... I do have a table listing the product codes and descriptions, ...
    (microsoft.public.access.forms)
  • Re: Populate text box based on entry in another text box
    ... I'm trying to set up a form in which if a user types a product code ... and set the textbox Text227's Control ... You can set the control source of Text227 to ...
    (microsoft.public.access.queries)
  • Re: preceding zero truncated
    ... The values reside on two controls are text. ... But they are in numeric text eg. product code '006700'. ... these texts, the preceding zero was truncated to '6700'. ...
    (microsoft.public.dotnet.languages.vb)