[MS_AccessPros] Add Edit of a form is locked

 

John,

I have a unbound main form "CST Participants Entry", its has only one unbound combobox "cboCstName" and its

Row Source is:

SELECT CST.CstName

FROM CST

ORDER BY CST.CstName;

Main form has one subform "Data Entry CST Account Sub Form"

Link Master Fields: cboCstName

Link Child Fields: CstName

Record Source of subform "Data Entry CST Account Sub Form" is:

SELECT DISTINCTROW [CST Transaction].MemberID, [CST Transaction].MembershipType, Members.SurName, Members.GivenName, [CST Transaction].GenderStatus, tblPassport.PassportNo, [CST Transaction].CstName, [CST Transaction].OutwardDate, [CST Transaction].OutwardDeparturePort, [CST Transaction].OutwardArrivalPort, [CST Transaction].InwardDate, [CST Transaction].InwardDeparturePort, [CST Transaction].InwardArrivalPort

FROM (Members INNER JOIN [CST Transaction] ON Members.MemberID = [CST Transaction].MemberID) INNER JOIN tblPassport ON Members.MemberID = tblPassport.MemberID

ORDER BY [CST Transaction].MemberID;

I am stuck in Data entry/Edit mode and entering new record.

Before this form was working properly. The change in design of this form is that before field "PassportNo"

was in tbl "Members", now i created a new table "tblPassport" which contains field "PassportNo"

Is my relationship wrong? or query design wrong, should i have to make one or two queries?

Please help.

Khalid

__._,_.___

---

Posted by: khalidtanweerburrah@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

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 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___