Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 30th, 2009, 12:25 AM
Registered User
Join Date: Mar 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default adding new data into existing fields?


im tasked to create a jukebox programme with access. i've a main switchboard form which allows for addition of new songs to the database. on the 'addition/modification of songs' form, ive allowed entries for song names, and also created subforms with dropboxes showing existing albums and artistes. this is done in bid of wanting to allow for new songs to be added to the database, and these songs can be from already existing albums/artistes. but somehow,when i try to add a new song, the subform with the dropbox showing albums and artistes is greyed out and the dropbox doesnt appear.

Old March 30th, 2009, 08:10 AM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

Is there a reason you need to have these selections in a sub form? I would have a song title text box, then an artist drop down, then an album list box or drop down, all populated on the previous selection, and the results stored as needed. It sounds like the query running your subform is not undateable.

Look it up at: http://wrox.books24x7.com

Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding existing Console/project ? chiefarchon BOOK: Beginning Microsoft Visual C# 2008 ISBN: 978-0-470-19135-4 0 September 19th, 2008 07:51 AM
VB.net, adding XML data to an existing XML file saikoboarder XML 11 April 17th, 2008 04:19 PM
Page 501/2 -Adding an existing file Nick Y BOOK: Ivor Horton's Beginning Visual C++ 2005 0 July 6th, 2006 03:28 AM
How to add fields to an existing table using VBA donrafeal Access VBA 3 March 22nd, 2006 06:11 PM
Adding existing and non-existing attributes spencer.clark XSLT 5 July 27th, 2005 04:02 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.