Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / February 2008

Tip: Looking for answers? Try searching our database.

Text box displaying columns from a combo box

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Don - 02 Feb 2008 02:03 GMT
I'm using text boxes to display the column data from a combo box. Trouble is
when I move to another record or close the form and ome back in, those
results are not displayed anymore and I have to reslect the values in the
combo boxes to fill in the text boxes. Is there a way to lock the results to
the text box for each record?

TIA
Signature

Don, Sydney Australia

Allen Browne - 02 Feb 2008 02:40 GMT
Don, I take it that you have a combo bound to a field in your table. When
the combo is dropped down, you see several columns, but when it's not
dropped down you can see only one. Therefore you have added some other text
boxes to your form to show those other columns, even when the combo is not
dropped down.

If this form is in Form view, (not Datasheet or Continuous), you could just
set the Control Source of the text boxes to read the data from the combo's
columns. For example, to show the value of the 3rd column of Combo3:
   =[Combo3].[Column](2)
(Note that the first column is zero, the next is 1, and so on.)

If the form shows multiple rows, you need a different solution. Create a
query to use as the source for this form. In the query, include your main
table, and the table the query gets its fields from (assuming that's a
many-to-one relation.) You can then add the fields you want from the combo's
table to the query, and then display them in the text boxes on your form.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I'm using text boxes to display the column data from a combo box. Trouble
> is
[quoted text clipped - 5 lines]
>
> TIA
 
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.