 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / March 2008Have a second text box auto fill when combo box is filled
This has to easy not requiring any programing. I have two columns in a table. One column is "customer name" the other is "customer code". I have a form where I currently use 2 combo boxes where I either select from a list or type each in. I would like to enter the "customer Name" and have the "Customer Code" complete its self when I enter over it or not even have to enter over it. Since they are both already in the same table it sounds like it should not require much to accomplish. Please keep this simple since I am a novice. You don't need to display both, except in the customer form itself. On that form, you need 2 text boxes. All other forms should display the customer name, but store the customer code. To do that, create a combo box with both columns, setting column 1's width to zero (0"), and column 2's width to whatever width will display it best. If you absolutely must display them both, read the customer code from the combo box by setting an unbound text box's controlsource to: NameofCombo.Column(0)  SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > This has to easy not requiring any programing. > I have two columns in a table. One column is "customer name" the other is [quoted text clipped - 6 lines] > same table it sounds like it should not require much to accomplish. > Please keep this simple since I am a novice. I will print the form so it must be visible to the operator. I think I understand. I will have to give this a try. The combo box will have two columns Column 1 will be the name and column 2 will be the code. Column 2 will have zero characters so it is not seen. I will use a text box for the code which will reference the combo box column 2. > You don't need to display both, except in the customer form itself. On that > form, you need 2 text boxes. All other forms should display the customer [quoted text clipped - 15 lines] > > same table it sounds like it should not require much to accomplish. > > Please keep this simple since I am a novice. The second column reference would look like: NameofCombo.Column(1) The column index is 0 based. SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com >I will print the form so it must be visible to the operator. I think I > understand. I will have to give this a try. The combo box will have two [quoted text clipped - 27 lines] >> > same table it sounds like it should not require much to accomplish. >> > Please keep this simple since I am a novice. |
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.