Read only form

  • Thread starter Thread starter Wayne
  • Start date Start date
W

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?
 
What have I done wrong?
Click to expand...

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!
 
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
 
Back
Top