 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / March 2005code information in a form
Hi, I have a form with a code text box on it, I want that when someone put a code in the texbox, in another texbox appears the description of the code, something like this: the user tipe in one text box: In the other text box appears automatically: 2 --> 3X5 Polypropilen Bag 60 --> 15X25 Polypropilen Bag It's important to say that I have 1250 different codes and I have allready typed all the codes with his description; The form is related to a query and code is one column of one table where are asked the code, amount of pieces and date of sale, but description is other column in other table (that cant be edited). PD, without using subforms . tks Filo, Include the "other table' in the query that your form is based on, joined to the main table on the Code field, and put the description field into the query. Then you can represent this field on the form with a textbox, and then set the Enabled property of the textbox to No and the Locked property to Yes so it can't be editied. Then, when the Code is entered on the form, the Description should automatically be displayed.  SignatureSteve Schapel, Microsoft Access MVP > Hi, I have a form with a code text box on it, I want that when someone put a > code in the texbox, in another texbox appears the description of the code, [quoted text clipped - 14 lines] > PD, without using subforms . > tks steve: I could send you my file if you want???? > Filo, > [quoted text clipped - 24 lines] > > PD, without using subforms . > > tks Ok, why not. Zip it up and email to me, and indicate which form and tables we are talking about. Remove the .ns from the return email address. SignatureSteve Schapel, Microsoft Access MVP > steve: I could send you my file if you want???? > [quoted text clipped - 26 lines] >>>PD, without using subforms . >>>tks Build a combo box that returns the codes as the 1st column, and the description as the 2nd column Then, simply for ht data source of the 2nd text box on your form, go: =([combo18].[column](1)) The beauty of this system is that you don't have to copy, or even store the descritpon text..and this is why relatonal databases are so cool!! SignatureAlbert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal@msn.com http://www.members.shaw.ca/AlbertKallal ohhh albert, you always solve my problems, thanks. also thanks to steve, but I have alrready tried what you typed and It didn't work > Build a combo box that returns the codes as the 1st column, and the > description as the 2nd column [quoted text clipped - 5 lines] > The beauty of this system is that you don't have to copy, or even store the > descritpon text..and this is why relatonal databases are so cool!! Filo, I am not sure what "didn't work" means, but what I suggested is standard procedure, and normally there is not problem with it. SignatureSteve Schapel, Microsoft Access MVP > also thanks to steve, but I have alrready tried what you typed and It > didn't work Ah, but I have a small detail, I want to use my form in datasheet view, when I type the code (or select the code from the combo box) all the other code records are changed¡¡¡ > Build a combo box that returns the codes as the 1st column, and the > description as the 2nd column [quoted text clipped - 5 lines] > The beauty of this system is that you don't have to copy, or even store the > descritpon text..and this is why relatonal databases are so cool!! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.