If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Forms with Combo Box
I have a form which has two separate line items, one is for part number and
another is for part description, each has its own combo box for selections. My questions is when I select the part number from the part number line and combo box is there a way to set it up so based on the part number selection, to automatically populate the part description line? |
#2
|
|||
|
|||
Forms with Combo Box
"Scout06" wrote in message
... I have a form which has two separate line items, one is for part number and another is for part description, each has its own combo box for selections. My questions is when I select the part number from the part number line and combo box is there a way to set it up so based on the part number selection, to automatically populate the part description line? Use an unbound textbox and refer to an additional column in the PartNumber combo: = cboPartNumber.Column(1) -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com |
#3
|
|||
|
|||
Forms with Combo Box
Arvin, thanks for your quick responce.
I have a table named Part Numbers and Descriptions, with two columns one Material No and the other Part Description. So when I create the unbound text box, will I use the = cboPartNumber.Column(1) as the entry for the control source or is there something more? thanks "Arvin Meyer [MVP]" wrote: "Scout06" wrote in message ... I have a form which has two separate line items, one is for part number and another is for part description, each has its own combo box for selections. My questions is when I select the part number from the part number line and combo box is there a way to set it up so based on the part number selection, to automatically populate the part description line? Use an unbound textbox and refer to an additional column in the PartNumber combo: = cboPartNumber.Column(1) -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com |
#4
|
|||
|
|||
Forms with Combo Box
Arvin,
ok I have it working now, were when you chose a part number form the combo box the description populates automatically. Now, is there a way to make the automatically populated part description, to now show up in the part description table? "Scout06" wrote: Arvin, thanks for your quick responce. I have a table named Part Numbers and Descriptions, with two columns one Material No and the other Part Description. So when I create the unbound text box, will I use the = cboPartNumber.Column(1) as the entry for the control source or is there something more? thanks "Arvin Meyer [MVP]" wrote: "Scout06" wrote in message ... I have a form which has two separate line items, one is for part number and another is for part description, each has its own combo box for selections. My questions is when I select the part number from the part number line and combo box is there a way to set it up so based on the part number selection, to automatically populate the part description line? Use an unbound textbox and refer to an additional column in the PartNumber combo: = cboPartNumber.Column(1) -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com |
#5
|
|||
|
|||
Forms with Combo Box
"Scout06" wrote in message
... Arvin, ok I have it working now, were when you chose a part number form the combo box the description populates automatically. Now, is there a way to make the automatically populated part description, to now show up in the part description table? Remember Relational Database principles. No duplication of data, and no data may depend upon another field other that the Key: "The Key, the Key, and nothing but the Key" So ... for proper design you definitely do not want to store the description more than once, and that once should be in the table which has the part number as the primary key. Now, you say, but I need to see it in reports. Ah! I say, go forth and build a query and all will be good. grin Post back with table and field names if you need further assistance. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com |
Thread Tools | |
Display Modes | |
|
|