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 8th, 2004, 11:56 PM
Registered User
Join Date: Mar 2004
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Want to insert a new record when an existing recor

Hi Frenz,

I have a main form and subform which are related through a key. The main form is not updateable while the sub form is ...Now in the table i want to maintain all the data ..which means if a user updates a record in the sub form i want to insert a new record for it rather than updating it ...so i am not able to decide the apt event to write the code ..also what code ...Kindly hlp me with a code snippet and the event as well


The Lion
Old September 9th, 2004, 11:55 AM
Friend of Wrox
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG

Why not set the form's ALLOW EDITS and ALLOW DELETIONS properties to NO and ALLOW ADDITIONS property to YES? That will only allow them to add data but not alter what's there.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Similar Threads
Thread Thread Starter Forum Replies Last Post
Add a new record between two existing records hsncompany BOOK: Beginning Access 2003 VBA 0 April 13th, 2008 03:36 PM
How to insert a column values in existing db (msac gilgalbiblewheel Classic ASP Databases 0 April 6th, 2005 06:53 PM
insert value of variable into an existing table mountaindew7612 SQL Server 2000 5 October 16th, 2004 12:48 PM
Insert new Record to MIDDLE of existing recordset? PanzarPaw Classic ASP Databases 5 September 11th, 2004 07:50 AM
Check for existing record echajmovic Access 1 November 3rd, 2003 08:03 PM

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