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
|
|||
|
|||
Combo box won't auto populate other fields
HI there.
I have a combo box on my form. When I click it, I want to have it populate the other fields on my form. This is an order form so when I click part abc, I want the price and description fields to be filled in. My parts table has an intPart key field, my orders table has this same field as well as my suppliers part number. I have related the two tables in a one to many relationship, enforcing referential integrity. What am I doing wrong here? Thanks! John -- www.brightfuture.ca/bright My email address can be found on my site. |
#2
|
|||
|
|||
Combo box won't auto populate other fields
Johnny
How have you "told" the combo box to do this? Are you using the AfterUpdate event to set the values in the other controls on your form? I assume these other controls are unbound, as it wouldn't be necessary or advisable to be storing duplicate values... Regards Jeff Boyce Microsoft Office/Access MVP "Johnny Bright" wrote in message ... HI there. I have a combo box on my form. When I click it, I want to have it populate the other fields on my form. This is an order form so when I click part abc, I want the price and description fields to be filled in. My parts table has an intPart key field, my orders table has this same field as well as my suppliers part number. I have related the two tables in a one to many relationship, enforcing referential integrity. What am I doing wrong here? Thanks! John -- www.brightfuture.ca/bright My email address can be found on my site. |
#3
|
|||
|
|||
Combo box won't auto populate other fields
I'm not using code to do this. I've seen this before where you have a form
based on a query, the source of the combo box is the primary key and description from the primary table and the form's underlying query has ALL the fields from the primary table and only the relevant ones from the 2nd table, ie quantity, date and PO number etc. When you click part abc, it gives you all the stuff from the primary table, in the form's various text boxes. I then type in quantity, date etc. How can I get the query to autopopulate my other text boxes? Thanks again, John -- www.brightfuture.ca/bright My email address can be found on my site. "Jeff Boyce" wrote: Johnny How have you "told" the combo box to do this? Are you using the AfterUpdate event to set the values in the other controls on your form? I assume these other controls are unbound, as it wouldn't be necessary or advisable to be storing duplicate values... Regards Jeff Boyce Microsoft Office/Access MVP "Johnny Bright" wrote in message ... HI there. I have a combo box on my form. When I click it, I want to have it populate the other fields on my form. This is an order form so when I click part abc, I want the price and description fields to be filled in. My parts table has an intPart key field, my orders table has this same field as well as my suppliers part number. I have related the two tables in a one to many relationship, enforcing referential integrity. What am I doing wrong here? Thanks! John -- www.brightfuture.ca/bright My email address can be found on my site. |
#4
|
|||
|
|||
Combo box won't auto populate other fields
"Johnny Bright" wrote: I'm not using code to do this. I've seen this before where you have a form based on a query, the source of the combo box is the primary key and description from the primary table and the form's underlying query has ALL the fields from the primary table and only the relevant ones from the 2nd table, ie quantity, date and PO number etc. When you click part abc, it gives you all the stuff from the primary table, in the form's various text boxes. I then type in quantity, date etc. How can I get the query to autopopulate my other text boxes? Thanks again, John -- www.brightfuture.ca/bright My email address can be found on my site. "Jeff Boyce" wrote: Johnny How have you "told" the combo box to do this? Are you using the AfterUpdate event to set the values in the other controls on your form? I assume these other controls are unbound, as it wouldn't be necessary or advisable to be storing duplicate values... Regards Jeff Boyce Microsoft Office/Access MVP "Johnny Bright" wrote in message ... HI there. I have a combo box on my form. When I click it, I want to have it populate the other fields on my form. This is an order form so when I click part abc, I want the price and description fields to be filled in. My parts table has an intPart key field, my orders table has this same field as well as my suppliers part number. I have related the two tables in a one to many relationship, enforcing referential integrity. What am I doing wrong here? Thanks! John -- www.brightfuture.ca/bright My email address can be found on my site. Hi, Johnny, This should hopefully fix your problem... Open the form in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.). Click Control Wizards in the toolbox if it's not already pressed in. In the toolbox, click List Box or click Combo Box . On the form, click where you want to place the list box or combo box. In the first wizard dialog box, click the option to find a record based on the value you selected in the list box or combo box. Follow the directions in the wizard dialog boxes. In the last dialog box, click Finish to display the list box or combo box in Design view. .... It's really all done by the wizard, you just need to select that first option to find a record based on the value you selected in the list box or combo box. Good Luck, Sonja. |
Thread Tools | |
Display Modes | |
|
|