Make Recordsets updateable on a Form in Access.

I've made a form from a query that has several enteries on it, so I created
combo boxes for the two items that have the various enteries in DESIGN form.
When I go into the application, the program tells me that the 'Recordset is
not updateable.'

What is wrong with it?

Is your form's record source (view it in datasheet view) updateable? What is
the SQL of your query.

--
Duane Hookom
MS Access MVP


"green_jello1701" wrote in
message ...
I've made a form from a query that has several enteries on it, so I
created
combo boxes for the two items that have the various enteries in DESIGN
form.
When I go into the application, the program tells me that the 'Recordset
is
not updateable.'

What is wrong with it?

The SQL is as follows:

SELECT Training_Records.Instructor,Training_Records.[Course_Name],
Sum(Training_Records.[Number of Hours]) AS [SumOfNumberofHours],
Avg(Training_Records.[Number of Hours]) AS [AvgOfNumberofHours],
Min(Training_Records.[Number of Hours]) AS [MinOfNumberofHours],
Max(Training_Records.[Number fo Hours]) AS [MaxOfNumberofHours],
FROM Training_Records
GROUP BY Training_Records.Instructor, Training_Records.[Course Name]
ORDER BY Training_Records.[COURSE Name];


"Duane Hookom" wrote:

Is your form's record source (view it in datasheet view) updateable? What is
the SQL of your query.

--
Duane Hookom
MS Access MVP


"green_jello1701" wrote in
message ...
I've made a form from a query that has several enteries on it, so I
created
combo boxes for the two items that have the various enteries in DESIGN
form.
When I go into the application, the program tells me that the 'Recordset
is
not updateable.'

What is wrong with it?

Group By queries are never updateable. Which field did you think you could
(or would want to) update?

--
Duane Hookom
MS Access MVP


"
m wrote in message
...
The SQL is as follows:

SELECT Training_Records.Instructor,Training_Records.[Course_Name],
Sum(Training_Records.[Number of Hours]) AS [SumOfNumberofHours],
Avg(Training_Records.[Number of Hours]) AS [AvgOfNumberofHours],
Min(Training_Records.[Number of Hours]) AS [MinOfNumberofHours],
Max(Training_Records.[Number fo Hours]) AS [MaxOfNumberofHours],
FROM Training_Records
GROUP BY Training_Records.Instructor, Training_Records.[Course Name]
ORDER BY Training_Records.[COURSE Name];


"Duane Hookom" wrote:

Is your form's record source (view it in datasheet view) updateable?
What is
the SQL of your query.

--
Duane Hookom
MS Access MVP


"green_jello1701" wrote in
message ...
I've made a form from a query that has several enteries on it, so I
created
combo boxes for the two items that have the various enteries in DESIGN
form.
When I go into the application, the program tells me that the
'Recordset
is
not updateable.'

What is wrong with it?

I want to update the Instructor and the Course to be updateable. For example,
I want to see Instructor X has how many hourse for Course B. That's how I
want both the query and the form to do.

"Duane Hookom" wrote:

Group By queries are never updateable. Which field did you think you could
(or would want to) update?

--
Duane Hookom
MS Access MVP


"
m wrote in message
...
The SQL is as follows:

SELECT Training_Records.Instructor,Training_Records.[Course_Name],
Sum(Training_Records.[Number of Hours]) AS [SumOfNumberofHours],
Avg(Training_Records.[Number of Hours]) AS [AvgOfNumberofHours],
Min(Training_Records.[Number of Hours]) AS [MinOfNumberofHours],
Max(Training_Records.[Number fo Hours]) AS [MaxOfNumberofHours],
FROM Training_Records
GROUP BY Training_Records.Instructor, Training_Records.[Course Name]
ORDER BY Training_Records.[COURSE Name];


"Duane Hookom" wrote:

Is your form's record source (view it in datasheet view) updateable?
What is
the SQL of your query.

--
Duane Hookom
MS Access MVP


"green_jello1701" wrote in
message ...
I've made a form from a query that has several enteries on it, so I
created
combo boxes for the two items that have the various enteries in DESIGN
form.
When I go into the application, the program tells me that the
'Recordset
is
not updateable.'

What is wrong with it?

If you just want to see Instructor X has how many hourse for Course B, what
is it you need to update?

It sounds to me as though you might have bound the Instructor and Course
Name fields from that query to combo boxes in your form's Detail section
display. What you want is to bind them to text boxes in the Detail, but have
combo boxes in the form's Header area that will let you set a filter.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"
m wrote in message
...
I want to update the Instructor and the Course to be updateable. For
example,
I want to see Instructor X has how many hourse for Course B. That's how I
want both the query and the form to do.

"Duane Hookom" wrote:

Group By queries are never updateable. Which field did you think you
could
(or would want to) update?

--
Duane Hookom
MS Access MVP


"
m wrote in message
...
The SQL is as follows:

SELECT Training_Records.Instructor,Training_Records.[Course_Name],
Sum(Training_Records.[Number of Hours]) AS [SumOfNumberofHours],
Avg(Training_Records.[Number of Hours]) AS [AvgOfNumberofHours],
Min(Training_Records.[Number of Hours]) AS [MinOfNumberofHours],
Max(Training_Records.[Number fo Hours]) AS [MaxOfNumberofHours],
FROM Training_Records
GROUP BY Training_Records.Instructor, Training_Records.[Course Name]
ORDER BY Training_Records.[COURSE Name];


"Duane Hookom" wrote:

Is your form's record source (view it in datasheet view) updateable?
What is
the SQL of your query.

--
Duane Hookom
MS Access MVP


"green_jello1701" wrote
in
message ...
I've made a form from a query that has several enteries on it, so
I
created
combo boxes for the two items that have the various enteries in
DESIGN
form.
When I go into the application, the program tells me that the
'Recordset
is
not updateable.'

What is wrong with it?