Read only form

[Wayne]

I've got a subform with a query as its recordsource. It
displays as a continuous form. When I open the form it
appears to be read only. Any existing records displayed
cant be edited at all and there is no blank record to enter
new data.
I didnt encounter any of these problems until I changed the
recordsource of the subform from a table to this query.

What have I done wrong?

 

[John Vinson]

What have I done wrong?

Probably used a non-updateable Query as the recordsource. If you open
the query itself, is it editable? I.e. does it have a *> "new record"
line at the bottom of the datasheet?

There are several reasons why queries might not be updateable: Totals
queries (or any query containing any Sum, Count, Group By, etc.
operator); UNION queries; DISTINCT queries...

But the most common cause is that you're joining two tables and you do
not have a unique Index on the "one" side table's joining field.

Perhaps you could post the SQL of the query if this doesn't help!

 

[Wayne]

Hi John,

Here's the SQL of the query I'm using:

SELECT [PrintReq_Sub Query1].PrintSubID,
PrintReq_Sub.PrintReqID, PrintReq_Sub.Date,
PrintReq_Sub.PrintsFor, PrintReq_Sub.RequestedBy,
PrintReq_Sub.Description, PrintReq_Sub.Type,
PrintReq_Sub.PaperSize, PrintReq_Sub.FirstQuantity,
PrintReq_Sub.Copies, PrintReq_Sub.PrintFee,
PrintReq_Sub.Postage, PrintReq_Sub.PostageFee
FROM PrintReq_Sub INNER JOIN [PrintReq_Sub Query1] ON
PrintReq_Sub.PrintSubID = [PrintReq_Sub Query1].PrintSubID
WITH OWNERACCESS OPTION;

The query above references the table PrintReq_Sub and
another query called PrintReq_Sub Query1:

SELECT PrintReq_Sub.PrintSubID, PrintReq_Sub.PrintReqID
FROM Print_Requisition LEFT JOIN PrintReq_Sub ON
Print_Requisition.PrintReqID = PrintReq_Sub.PrintReqID
WHERE
(((PrintReq_Sub.PrintReqID)=[Print_Requisition].[PrintReqID]));

This was the only way I could get my sub form to display
the correct data.

You were right, I opened the query and there is not a new
record line at the bottom. I still have no idea whats wrong.

Hope you can help....Thanks