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 / May 2008

Tip: Looking for answers? Try searching our database.

Saving data selected from a list box to a table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Erika - 02 May 2008 05:59 GMT
I have 2 multi-select list boxes on a form but none of the data selected is
saved to the table with other data selected via combo boxes, or entered as
frree text or dates.  How do I get the data to save (I am not trying to save
back to the table referenced by the list boxes).
Signature

Erika

Jeff Boyce - 02 May 2008 13:10 GMT
Erika

If you are using "multi-select list boxes" the implication is that there is
a one-to-many relationship between the data/record represented by the rest
of  your form and the selections in (each of) the list boxes.

To get the best out of Access' relationally-oriented features/functions,
you'll need to store your data relationally.  If you really do have a couple
one-to-many relationships, you'll need at least one additional table per
list box.  The additional table(s) will hold the recordID of the form's
record and the recordID of (each) selection on the list box.  ?4 items
selected? ... 4 records in the new table.

Signature

Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

> I have 2 multi-select list boxes on a form but none of the data selected is
> saved to the table with other data selected via combo boxes, or entered as
> frree text or dates.  How do I get the data to save (I am not trying to save
> back to the table referenced by the list boxes).
 
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.