Is GD-I a linked SQL Server table? I didn't think an Access table was required to have a primary key (although it should be required). I suppose I could test this quite easily when I have a minute or two.
Regards,
Duane Hookom
Vevey, Switzerland
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of John Viescas JohnV@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, January 26, 2017 1:00 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Cannot add new records on continuous sub form
Sent: Thursday, January 26, 2017 1:00 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Cannot add new records on continuous sub form
Khalid-
If I remember correctly from previous discussions, table GD-I does not have a Primary Key. That's the problem.
John Viescas, author
John Viescas, author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Access Applications
www.viescas.com Welcome to the home of John Viescas Consulting. If you’re at all interested in Microsoft Access or SQL Server, this is the place to be! Check out the book ... |
On Jan 25, 2017, at 18:39, Khalid Tanweer khalidtanweerburrah@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hi John,
I am having problem in adding new record on a continuous sub form. I have changed design of form "GDI" and its sub form "GDIsubform".
Main form "GDI" has only one Unbound Combo Box "ConsiignmentNo" having Row Source:
SELECT DISTINCT [Consignment Number].ConsignmentNo
FROM [Consignment Number]
ORDER BY [Consignment Number].ConsignmentNo DESC;
Record Source of "GDIsubform" is table "GD-1". On Property Sheet of Sub form "GDIsubform" the settings are:
Data Entry-->No
Allow Additions-->Yes
Allow Deletions-->Yes
Allow Edits-->Yes
Allow Filters-->Yes
Record Locks-->No Locks
Link Master Fields-->ConsignmentNo
Link Child Fields-->ConsignmentNo
I often have this problem while creating new forms or changing design of forms.
Help needed please.
Regards,
Khalid
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (8) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar