 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / September 2004Form combo box question
Is it possible to have a field in a table ( A) such as social security # that takes a number as data. It is linked to a table (B) that has the Name and SSN in it for the combo box drop down with appropriate relationship. But the form for table A does not let you see the SSN just the name but the SSN is stored in the table A.SSN. When you click on the drop down to choose a new SSN you see both the name and the SSN but once you choose a Name,SSN the SSN goes into the table but the user sees only the Name? The property for Lookup and Bound Column and column count seem unable to do this. There is a simple tool in Oracle Forms that does this for you. Thanks Rob Rob, I'm pretty sure what you're describing is the default behavior or a combo box. Create a simple join query for your Name and SSN so that your returning a name field and the SSN field. Set that as your Row Source. Set your column count to two, the column widths appropriately to be able to view everything (name might be a bit long), and set the bound column to 1. When you select the dropdown, you should see both the name and the SSN in two columns, but after selecting the value, you should only see the first column that has a width greater than 0. If that doesn't work as you were seeking, please clarify what's missing. HTH, Pat > Is it possible to have a field in a table ( A) such as social security # > [quoted text clipped - 11 lines] > Thanks > Rob Thanks Pat you have it exactly the way I did it. The problem is that my users would rather not see The bound column ( SSN which is what the table calls for ) What I would like to do is have the drop down do exactly what you are saying but after you choose the SSN,Name the Name shows in the form box not the SSN even though the SSN is being saved at the table level. Obviously if I choose Name or 2 as the bound column ( Assuming my query was written as SSN,Name (1,2) then after I choose the SSN,Name from my drop down the table will complain because I am trying to put a text into a number datatype. That is not what I want. I only want to see the name at the form level but the SSN in the table. It is really just for the end user not to have to look at SSN. Thanks again for the time. Rob If you only want to store the SSN but see the name, then why not set the column width on the first column to zero? Rob, You just need to reverse the field order on your combo box. Instead of SSN, Name (bound col 1), you want Name, SSN (bound col 2). Access will always display the first visible field after a combo selection. HTH - Reply back if not. Pat > Thanks Pat you have it exactly the way I did it. > The problem is that my users would rather not see The [quoted text clipped - 12 lines] > Thanks again for the time. > Rob |
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.