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 September 3rd, 2004, 02:38 PM
Registered User
 
Join Date: Sep 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Adding new record in Access 2003 adp subform

I have a subform in an Access 2003 adp that I need to add new records to (as well as view and change records). The view and change work fine, but I can't add. I could open a different form to add the new record, then return to the original form and retrieve the new record, but I don't like that interface (rather have everything on one form). Is it possible in an adp?


 
Old September 4th, 2004, 04:41 PM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

Check you subform properties and make sure that under "unique Table" you have select a table name that corresponds to your forms query/view or stored procedure. Check also 'allow addition" is set to yes





Similar Threads
Thread Thread Starter Forum Replies Last Post
access adp subform connected to sql 2005 skype Access 1 February 5th, 2007 08:45 AM
Adding New Record to Access Database Using VB.NET TechHelp ASP.NET 1.0 and 1.1 Basics 1 September 13th, 2006 03:19 AM
Access 2003 - Adding Textbox at runtime? ashish_kamdar BOOK: Access 2003 VBA Programmer's Reference 5 February 17th, 2006 01:18 PM
Adding records using form and subform marcin2k Access VBA 3 March 7th, 2005 04:37 PM
Subform only may contains 1 record Stanny Access 5 December 21st, 2004 11:17 AM





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