Access 2007 Tabbed form with shared recordset

Alen Darr

Guest

Posts: n/a

12th Nov 2010

I have a tabbed form that has multiple forms each displaying information from a main table. When a record is edited, the forms work as expected. When a new record is added - A null key error is thrown by the duplicate sets. To combat this I have turned off record locking, tryed me.refresh in the form_current procs, after_update and after_insert methods. How do you get access to share the recordset between forms (in add mode)?

Submitted via EggHeadCafe
ASP.NET Composite Controls
http://www.eggheadcafe.com/tutorials...-controls.aspx

« Persistent variable? | VBA Syntax for subform record source change »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Programmatically open a form in tabbed mode - Access 2007	Silvio	Microsoft Access Forms	0	2nd Oct 2009 03:01 PM
Access 2007 GUI: not(tabbed) ?	Allen_N	Microsoft Access Getting Started	2	4th Nov 2008 09:54 PM
Split Form (Access 2007) doesn't show on a tabbed form?...	efandango	Microsoft Access Forms	2	30th Apr 2008 01:04 PM
Tabbed metaphor for form in 2007	Mark	Microsoft Access	1	24th Mar 2008 03:32 PM
Adding a split form to a tabbed page access 2007	=?Utf-8?B?U2h5dG93bl9UdXJr?=	Microsoft Access Form Coding	0	19th Oct 2007 10:00 PM