RE: [MS_AccessPros] Cannot add new records on continuous sub form

 

The sub-form is missing a field required for Access to add a new record to the table or one of the tables in the record source.

 

 

Bob Peterson

 

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, January 25, 2017 1:43 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Cannot add new records on continuous sub form

 

Duane,

 

Yes the problem is i cannot see a New (Blank) Record button on Navigation Buttons and i am not getting any error message.

 

These are same settings for the main form:

Data Entry-->No

Allow Additions-->Yes

Allow Deletions-->Yes

Allow Edits-->Yes

Allow Filters-->Yes

Record Locks-->No Locks

 

Regards,

Khalid

 

---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :

Khalid,

 

Can you add a little more information about "problem"? Do you not see a new blank record or are you getting an error message?

 

What are these same settings for the main form:

Data Entry-->No

Allow Additions-->Yes

Allow Deletions-->Yes

Allow Edits-->Yes

Allow Filters-->Yes

Record Locks-->No Locks

 

 

Regards,

Duane Hookom

Switzerland

 

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Khalid Tanweer khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, January 25, 2017 11:39 AM
To: Access Professionals Yahoo Group
Subject: [MS_AccessPros] Cannot add new records on continuous sub form

 

 

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: Robert Peterson <bob@alternatefinishing.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

---

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.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___