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

 

John / Duane,

Sorry for replying late because i have gone through a problem and was not getting any solution by my own.

The problem was that my PCTL.accdb became corrupt, many times while typing the code when i pressed DOT key it got an error and access went to restarting and creating Backup file. I have no knowledge why it happened again and again now.

I was working on Duane's suggestion to make a new main form and add subform to it, i did that and checked New (Blank) Record button was enable, but as i have shifted some controls up and down, while going to save it was not saving, again and again Save-No-Cancel message appeared even if i clicked on Save.

I hope the problem will be resolved with Duane's suggestion. Now my question is as PCTL.accdb has been corrupt can i delete PCTL.accdb and rename PCTL_Backup.accdb to PCTL.accdb, and will it work as PCTL.accdb.

If i open backup file it works.

Regards,

Khalid

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

Khalid-

If I remember correctly from previous discussions, table GD-I does not have a Primary Key.  That's the problem.

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

http://www.viescas.com/

On Jan 25, 2017, at 18:39, Khalid Tanweer khalidtanweerburrah@... [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: khalidtanweerburrah@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (9)

---

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

.

__,_._,___