 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / January 2008auto fill records with combo box
I am trying to create a simple subform but for some reason it is not working. Table 1 - tblequipmentprice (This table is fixed priced) one to many to table 2 ID - (PK) DESCRIPTION UNIT PRICE Table 2 - tblinstallqty IDqty (PK) quantity ID I am trying to create a subform where I can select DESCRIPTION from a combo box and it auto fills the records for UNIT and PRICE. Then the only information that needs to be inputed is the QUANTITY field. The problem I am having is when I select from the combo box it pulls the records back into table 1 (which shouldn't). I have tried to do a query but still have the same problem. You mentioned putting "DESCRIPTION" in a subform. What's in the main form?  SignatureRegards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ > I am trying to create a simple subform but for some reason it is not working. > [quoted text clipped - 17 lines] > records back into table 1 (which shouldn't). I have tried to do a query but > still have the same problem. Basic customer information. >You mentioned putting "DESCRIPTION" in a subform. What's in the main form? > [quoted text clipped - 3 lines] >> records back into table 1 (which shouldn't). I have tried to do a query but >> still have the same problem. Basic customer information. >You mentioned putting "DESCRIPTION" in a subform. What's in the main form? > [quoted text clipped - 3 lines] >> records back into table 1 (which shouldn't). I have tried to do a query but >> still have the same problem. I guess I'm not understanding why a particular thing (with a DESCRIPTION) would have many "Quantities". I guess I don't understand enough about what business need you are trying to solve... SignatureRegards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ > Basic customer information. > [quoted text clipped - 5 lines] > >> records back into table 1 (which shouldn't). I have tried to do a query but > >> still have the same problem. DESCRIPTION is the source for my combo box. I just want to create a simple form where you select a "description" and it auto fills the set price for that value. Example of what I want on my form. DESCRIPTION (combo box, choose a value and it pulls the correct price) PRICE (auto filled) QUANTITY (enter quantity) TOTAL PRICE (=[price]*[quantity]) I have tried creating the form from a query but it wouldn't work. When I choose a "description" it would add a new record back into the table it was pulling the information from. >I guess I'm not understanding why a particular thing (with a DESCRIPTION) >would have many "Quantities". [quoted text clipped - 7 lines] >> >> records back into table 1 (which shouldn't). I have tried to do a query but >> >> still have the same problem. You're describing the form. I'm talking about the underlying data. In Access, it all starts with the data. SignatureRegards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ > DESCRIPTION is the source for my combo box. I just want to create a simple > form where you select a "description" and it auto fills the set price for [quoted text clipped - 22 lines] > >> >> records back into table 1 (which shouldn't). I have tried to do a query but > >> >> still have the same problem. Table 1 ID- Auto Number - PK Description - text Unit - text Price- Currency Table 2 IDqty - Auto Number PK ID- Number quantity - number >You're describing the form. I'm talking about the underlying data. In >Access, it all starts with the data. [quoted text clipped - 4 lines] >> >> >> records back into table 1 (which shouldn't). I have tried to do a query but >> >> >> still have the same problem. If you only describe your current structure, and don't provide information about WHY you are using that structure (i.e., what business area this covers), it will be tough to offer relevant suggestions. My previous question stands ... What kind of thing has a one-to-many relationship between "unit" and "quantity"? SignatureRegards Jeff Boyce www.InformationFutures.net Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ > Table 1 > ID- Auto Number - PK [quoted text clipped - 15 lines] > >> >> >> records back into table 1 (which shouldn't). I have tried to do a query but > >> >> >> still have the same problem. http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200801/1 |
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.