Cannot Add Record

S

sljack

I have a form that operates from the following query:

SELECT tblCaseInfo.*, tblStatus.ClosedDate, tblRegion.ID, tblRegion.SUBOFC,
tblRegion.PM, tblRegion.PMPH, tblRegion.Ext, tblRepresentatives.*,
tblAction.Actn, tblAction.NoticeDate, tblAction.Imposed, tblAction.Appeal,
tblAction.Program, tblAction.Surveys, tblAction.IDROutcome,
tblAction.TotalImposedAmt
FROM (((tblRepresentatives RIGHT JOIN tblCaseInfo ON tblRepresentatives.ID =
tblCaseInfo.RepID) LEFT JOIN tblRegion ON tblCaseInfo.FieldOfc =
tblRegion.ID) LEFT JOIN tblStatus ON tblCaseInfo.CaseId = tblStatus.CaseId)
LEFT JOIN tblAction ON tblCaseInfo.CaseId = tblAction.CaseID;

However, when I attempt to add a record I can enter information into fields
belonging to all the tables except tblAction. I get an error message when I
try to enter data into the field: tblAction.Actn. It will not allow me to
make an entry unless I exit the form and then reopen the form and then I am
able to make an entry into the tlbAction table. Is there a problem with the
query or the relationship between the tables?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble with Query Statement 2
How do I assign an unbound object in a report? 1
Duplicate Data 0
This doesn't work 9
Like Expression in Query 5
Combo Box Help 2
Help With Cascading Combo Boxes 1
On click add record 1

Top