Updating in a Form with a Query assigned to the Form

[Sorting in a Graph]

I need to know how to make a form updatable when a query is assigned to the
form. It tells me that the query needs to be updatable to allow fields to be
updated.

 

[John W. Vinson]

I need to know how to make a form updatable when a query is assigned to the
form. It tells me that the query needs to be updatable to allow fields to be
updated.

A Form cannot make a non-updateable query into an updateable one. You need to
fix the Query instead!

Perhaps you could post the SQL view of the query; there are many reasons why a
query might not allow updating, perhaps someone can suggest how to fix this
one.

 

[Sorting in a Graph]

Here's the SQL view. How can I change it to be updatable?

SELECT Projects.*, Projects.[Year of Project], [Business Units].[Sort
Order], Projects.[Project name]
FROM Projects INNER JOIN [Business Units] ON Projects.[Business Unit] =
[Business Units].[Business Unit]
WHERE (((Projects.[Include in Slide Show])="Yes"))
ORDER BY Projects.[Year of Project], [Business Units].[Sort Order],
Projects.[Project name];

 

[John W. Vinson]

Here's the SQL view. How can I change it to be updatable?

SELECT Projects.*, Projects.[Year of Project], [Business Units].[Sort
Order], Projects.[Project name]
FROM Projects INNER JOIN [Business Units] ON Projects.[Business Unit] =
[Business Units].[Business Unit]
WHERE (((Projects.[Include in Slide Show])="Yes"))
ORDER BY Projects.[Year of Project], [Business Units].[Sort Order],
Projects.[Project name];

First thing to try: Make [business Unit] the Primary Key of [Business Units],
and use the Relationships window to ensure that there is a relationship
between [Projects] and [Business Units] on the [Business Unit] field.