 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008List Box or Combo Box Better?
Currently I have a Form where I have to enter the Employee Number, Name, and Pay Rate each time I enter a record. I have another table that lists just this information for each employee. Would it be possible to change the Employee Number to either a list box or combo box to choose the number then have it populate the other information automatically (i.e., choose the employee number, then the name and pay rate fields for that record will be filled in without me having to type the data each time)? If so, how would I do this? Which is better, a list box or combo box? I appreciate any assistance you might be able to give me!  SignatureJWeaver It is not necessary to store information associated with the employee in another table if you store the primary key for the Employee table. Read the combobox Example in 'Access Basics' (combobox and listbox are analogous for this example) Access Basics (on Allen Browne's site) http://www.allenbrowne.com/casu-22.html 8-part free tutorial that covers essentials in Access Allen has a wealth of information on his site; after you get to the bottom of this link, click on 'Index of Tips' Warm Regards, Crystal * (: have an awesome day :) * > Currently I have a Form where I have to enter the Employee Number, Name, and > Pay Rate each time I enter a record. I have another table that lists just [quoted text clipped - 6 lines] > > I appreciate any assistance you might be able to give me! As Crystal mentions, only store it once. The only information that needs to be stored repeatedly is the key (in your case [Employee Number]) Using either a combo or list box you can display multiple columns, but with a list box, it is easier since you don't have to read the data a second time. One other thing, if you are calculating pay, based on pay rate, you will need to store the rates in a separate table, since they are likely to change and you don't want to change existing calculations. You could instead store the results of the calculation, but it is significantly better to store all the elements of that calculation. SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > Currently I have a Form where I have to enter the Employee Number, Name, > and [quoted text clipped - 9 lines] > > I appreciate any assistance you might be able to give me! |
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.