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 / General 2 / March 2007

Tip: Looking for answers? Try searching our database.

Lists Box

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Asif - 29 Mar 2007 10:52 GMT
I have a form with fields; ID, DATE and QUANTITY. The Date and
Quantity Field I've changed into a List Box showing the two columns
respectively and the ID field is left as a normal text box. When I
click on any item in the list box the ID change change according to
which ever entry I have selected. Unfortunetly ID field stays
constant!!

Any suggestions

Thanks
Vladimír Cvajniga - 29 Mar 2007 17:22 GMT
Hi, Asif,

did you include the ID field in the ListBox?

The easiest solution:
1) Add the ID field to the RowSource.
2) Point the BoundColumn to the ID field.
3) Set the ID field column width to 0.

HTH

Vlado

>I have a form with fields; ID, DATE and QUANTITY. The Date and
> Quantity Field I've changed into a List Box showing the two columns
[quoted text clipped - 6 lines]
>
> Thanks
 
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.