Query has become uneditable

S

Susan L

A query was formerly working and then stopped being editable. I redid the
table relationships after finding a post on the topic in the newsgroups.
(Aplogies for the length)

Here is the current setup. There are two tables in the query, which is the
record source for a form DeploySchedule. The first table (DeploySchedule) has
a PK of "StateID" (autonumber) and the second table (DeployDetails) has a FK
of "StateID." The relationship is set to one-to-many (first to second table
on StateID).

How it’s supposed to work: The user enters planned dates in the
DeploySchedule form. Using the DeployRecords form (record source – a query on
DeployDetails table), the user creates records by selecting a project Action
from a combo box. When the selected Action has a scheduled date on
DeploySchedule, such as “Teleconference Scheduledâ€, an expression in the
query populates the DeployRecords form’s date field (CallDate) on the record.

Here’s an example of the expression:
ActualTeleconfDate: Max(IIf([tbl_Deployment_Details]![Action] In
("Teleconference Scheduled","Teleconference
Rescheduled"),[tbl_Deployment_Details]![CallDate]))

In addition, the query contains a field (Action) from the DeployDetails
table, with the following criteria:
In ("Teleconference Schedules","Teleconference Rescheduled") Or Is Null

Can anyone suggest what to do to get this to work? Earlier I tried DLookup,
but was unable to get it working.
 
Top